How many types of cursors are there in SQL Server?
Answer Posted / santosh kumar sharma
There are 4 types of cursor.
1) Static: Cursor can move to any record but the changes on
the data can't be seen.
2) Dynamic: Most resource extensive. Cursor can move
anywhere and all the changes on the data can be viewed.
3) forward-only: Cursor moves one step forward. Can't move
backwards.
4) Key setdriven: Only Updated data can be viewed. Deleted
and Inserted data cannot be viewed.
Is This Answer Correct ? | 18 Yes | 3 No |
Post New Answer View All Answers
What are the types of database schema? : sql server analysis services, ssas
Explain tables in SQL Azure?
Define constraints and give an example of their use?
Find nth lowest salary or get nth lowest salary?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
Introduction of rollup clause using sum and group by clause?
What are the components of sql server service broker?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
How to provide column names in insert statements in ms sql server?
What is difference between table aliases and column aliases? Do they affect performance?
What are the types of indexes?
What is measure group, measure? : sql server analysis services, ssas
How to update values in a table with update statements in ms sql server?
What is 2nf normalization?
How can I create a report based on a query? : sql server management studio