How many types of cursors are there in SQL Server?
Answer Posted / vikash kumar mishra
There are five type of cursors in SQL server.
1)Base table:- This is lowest level cursor.
2)Static :- This is scrollable query cursor in earlier
versions of SQL Server Compact Edition
3)Forward-only:- The forward-only cursor is the fastest
cursor that you can update, but it does not support
scrolling.
4)Forward-only/Read-only:- Forward-only/read-only cursors,
referred to as forward-only cursors in earlier versions of
SQL Server Compact Edition, are the fastest cursors, but
cannot be updated.
5)Keyset-driven:- The keyset-driven cursor in SQL Server
Compact Edition is a scrollable cursor that you can update.
A keyset-driven cursor is controlled by a set of physical
identifiers known as the keyset.
Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
What protocol does sql server use?
How extra digits are handled with numeric data type literals?
What is BLOCK statements in SQL?
how to trace the traffic hitting a sql server? : Sql server database administration
What are tables in sql server?
Can a rule be bound to any column of any data type?
What are indexers?
What is best institute to Learn DotNET And SQL in chennai?
explain different types of constraints? : Sql server database administration
What will be the maximum number of index per table?
What is lock escalation? : sql server database administration
What is system stored procedures?
How are the unique and primary key constraints different?
What is application role in sql server database security? : sql server security
Explain how to send email from sql database?