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
what is denormalization? : Sql server database administration
explain different types of cursors? : Sql server database administration
When I delete any data from a table, does the sql server reduce the size of that table?
What the class forname () does?
Explain view in sql server?
Which tcp/ip port does sql server run on? How can it be changed?
Can a trigger be created on a view?
what is a live lock? : Sql server database administration
What are the differences between having and where clause.
What are the joins in sql server? : sql server database administration
How would you use user_constraints table in DB?
Do you know query execution plan?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
Tell me about builtinadministrator?
