Interested to Buy Any Domain ? << Click Here >> for more details...
How many types of cursors are there in SQL Server?
- 5 Answers
- 22489 Views
- 247Customer, CarrizalSoft Technologies, I also Faced
- E-Mail Answers
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
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is the difference between NOROW and LOCKROW?
Explain the use of keyword with encryption. Create a store procedure with encryption?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
Can we insert data into view sql server?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What are “phantom rows”?
What is the user of Primary key?
What is read uncmmited?
How to create a dynamic cursor with the dynamic option?
What is delete query?
Why use stored procedures in sql server?
What is difference between table aliases and column aliases? Do they affect performance?
How to create a new table in a given schema?
Write a program to fetch first 10 records from a file?
