Answer Posted / ravi148

hi,

dileep is exactly correct , arun .. iam sorry to say ur
wrong

suppose for employee table, write as
DECLARE curTemp SCROLL CURSOR FOR
SELECT TOP 2 * from EMPLOYEE
OPEN curTemp
FETCH LAST FROM curTemp
CLOSE curTemp
DEALLOCATE curTemp

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1305

---

Can you please explain the difference between function and stored procedure?

546

---

How to connect a database with sql express.?

572

---

What different steps will a sql server developer take to secure sql server?

506

---

What are the rules to use the rowguidcol property to define a globally unique identifier column?

593

---

---

List down some advantages of sql stored procedure?

564

---

What is the filtered index?

563

---

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

498

---

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

1557

---

How do I find the sql server instance name?

531

---

Can primary key be null?

515

---

What do you mean by tablesample?

641

---

What is the use of sql profiler in sql server 2012?

515

---

How to generate create view script on an existing view?

562

---

What is sql server used for?

558

---