Interested to Buy Any Domain ? << Click Here >> for more details...
How many types of cursors are there in SQL Server?
- 5 Answers
- 22629 Views
- 247Customer, CarrizalSoft Technologies, I also Faced
- E-Mail Answers
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
Why I am getting this error when dropping a database in ms sql server?
What are pessimistic lock and optimistic lock?
How to provide login information for a new odbc dsn?
Do you know query execution plan?
How many columns can we include on clustered index ?
What are the common performance issues in sql server?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
What are window functions in sql server?
Is foreign key a primary key?
What is a fill factor?
What is indexing a document?
What is the new security features added in sql server 2014? : sql server security
Can we call stored procedure in view in sql server?
Explain error handling in ssis?
What the different topologies in which replication can be configured?
