Interested to Buy Any Domain ? << Click Here >> for more details...
How many types of cursors are there in SQL Server?
- 5 Answers
- 22485 Views
- 247Customer, CarrizalSoft Technologies, I also Faced
- E-Mail Answers
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
How to check if a table is being used in sql server?
What is database black box testing?
What is the difference between substr and charindex in the sql server?
Difference between Sql server reporting services and Crystal reports?
What is a unique key constraint?
What sql server means?
What is the command to change the recovery model?
What is the meaning of sql server?
how can u get last observation in an unknown dataset ?
Explain concepts of analysis services?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
What are the types of table?
What are the pre-defined functions in the sql server?
What should be the fill factor for indexes created on tables? : sql server database administration
Explain a checkpoint?
