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 is a constant or literal in ms sql server?
What are locks in sql?
What are temporal tables in sql server 2016?
What is difference between getdate and sysdatetime in sql server 2008?
Explain “row_number()” in sql server with an example?
What do you mean by recursive stored procedure?
What do mean by xml datatype?
What will happen if a column containing char type data is changed to the nchar data type?
What are different types of views?
What is the return type of executeupdate ()?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Would you store your query in a ssrs report or a database server? State the reason why?
Why should you use or avoid select * statements?
Where sql server usernames and passwords are stored in a sql server?
List the various tools available for performance tuning?