Answer / anindya basu

There are four types of cursor in SQL Server which are:

a. Static
b. Dynamic
c. Forward Only, and
d. Keyset
Static keysets aren't sensitive to database changes and are scrollable.
Dynamic keysets are sensitive to database changes and are scrollable.
Forward only keysets aren't sensitive to database changes and allows only forward scrolling of data. There are 3 variants of Forward Only cursors viz. Forward Only Static, Forward Only Keyset, and Fast Forward. Fast Forward is the fastest of all cursors.
Keyset cursor supports movement from the first row to the last and vice-versa. It doesn't identify inserts but recognizes both updates and deletes.

What is the library index called?

0 Answers  

---

Name few of the dcl commands in sql?

0 Answers  

---

How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn't have a Monitor server and Witness server?

2 Answers   IBM,

---

Can we rollback records deleted by a truncate statement?

3 Answers   CarrizalSoft Technologies, United Healthcare,

---

Why use cursor in sql server?

0 Answers  

---

---

What is difference between index seek vs. Index scan?

0 Answers  

---

what's the difference between a primary key and a unique key? : Sql server database administration

0 Answers  

---

What is difference between delete and truncate commands?

0 Answers  

---

Describe how to use the linked server?

0 Answers  

---

What is an index. What are the types?

0 Answers  

---

Do you know how to send email from database?

0 Answers  

---

What is a non-clustered index?

0 Answers  

---