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
What is the server name in sql server?
Do you know what are the ways available in sql server to execute sql statements?
What is sql profiler. What are the default templates with it? : sql server database administration
What are user-defined functions (udfs) in sql server?
what is raid? : Sql server database administration
What does it mean to invest in the index?
Relational calculus is what type of language?
How to convert binary strings into integers in ms sql server?
How to override dml statements with triggers?
What is use of except clause?
What are the different types of backups avaialabe in sql server 2005?
Explain what is lock escalation and what is its purpose?
Explain trigger and trigger types?
What are tables in sql server?
Explain comment on transactions?