How many types of cursors are there in SQL Server?
Answer Posted / sandip borkar
There can be 7 types of Cursors in SQL Server
1] Dynamic : Scrollable. Its slowest, and sensitive to all changes in resultset.
2] Keyset : Scrollable. Its slow but faster than Dynamic.Sensitive to Changes like updation and deletion but not insertion
3] Static : Its srollable and faster than both above. We can move forward and backward, but changes are not visible
4] Forward_Only Dynamic : Its not scrollable, but sensitive to changes.
5] Forward_only keyset : Its not scrollable, but sensitive to updation and deletion in resultset but not insertion. We can only move forward and not backward.
6] Forward_only Static : Not sensitive to changes not scrollable.
7] Fast-forward : fastest among all.
Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
Tell me about joins in database system and explain each in detail.
System requirements for sql server 2005 express edition?
What is data mart? : sql server analysis services, ssas
What is Cross Join and in which scenario do we use Cross Join?
What are information schema views?
Explain different types of locks in sql server.
What is difference between primary key and foreign key?
what are the types of indexes? : Sql server database administration
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
How to create a view with data from multiple tables?
What is RAID? What are the different types of RAID configurations?
Explain cross join or cartesian product in sql?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
How to round a numeric value to a specific precision?
Difference between LEN() and DATALENGTH() in sql server ?