Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to check status of stored procedure in sql server?
What is constraints and its types?
Explain “@@rowcount” and “@@error” in sql server?
How to get all stored procedures in sql server?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
what exactly sql injuction.how to overcome.....
How many triggers you can have on a table?
What are the different SQL Server Versions you have worked on?
What authentication modes does sql server support?
What is 3nf normalization form?
Define compound operators?
Can we use where clause with group by?
What is equi join with example?
What is report rendering ?
What are drillthrough reports?
