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.

How to use column default values in insert statements in ms sql server?

1 Answers  

---

Psudo colums

1 Answers   HP,

---

How to disconnect from a sql server using mssql_close()?

1 Answers  

---

What is the recovery model? List the types of recovery model available in sql server?

1 Answers  

---

How to view the error log for any specific instance? : sql server database administration

1 Answers  

---

Please illustrate physical database architecture? : SQL Server Architecture

1 Answers  

---

Can we perform backup restore operation on tempdb? : sql server database administration

1 Answers  

---

How to populate a table in sql server?

1 Answers  

---

How to create a store procedure with encryption?

1 Answers  

---

List out the differences between the clustered index and non-clustered index in sql server?

1 Answers  

---

What is the size of transaction log file?

1 Answers  

---

What is user defined datatypes and when you should go for them?

1 Answers  

---