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 are the benefits of using stored procedures over sql statements?

3 Answers   Ness Technologies,

---

What are the recovery models for a database?

0 Answers  

---

What are the different Authentication modes in SQL Server and how can you change authentication mode?

0 Answers  

---

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

0 Answers  

---

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

0 Answers   HCL,

---

---

What is apply operator in sql?

0 Answers  

---

What is cross join in sql server joins?

0 Answers  

---

What is index?

1 Answers   Cap Gemini,

---

WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

1 Answers   Synergy,

---

What are recommended options to be used while using db mirroring? : sql server database administration

0 Answers  

---

What are the properties of sub-query?

0 Answers  

---

How do I know if localdb is running?

0 Answers  

---