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
How do I view a stored procedure in sql server?
Why we need sql server?
What are the ways available in sql server to execute sql statements?
What is parameterized reports in ssrs ?
What are the different types of sql server replication? : sql server replication
What is recompile sql server?
What is the difference between NOROW and LOCKROW?
What is normalization according to you and explain its different levels?
Explain some stored procedure creating best practices or guidelines?
What is the difference between a clustered index and a non-clustered index?
Explain transaction isolation levels in sql server?
How to list all stored procedures in the current database using ms sql server?
explain different types of joins? : Sql server database administration
What is set nocount on?
Which database stores information about replication?