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
where the connection string store in the database
What specific conditions database should meet, before you can bulk copy data into it using bcp?
Explain the phases a transaction has to undergo?
Explain having clause and where clause?
What command is used to create a database in the sql server and how?
What is report rendering ?
Do you know what are the ways available in sql server to execute sql statements?
Define primary key?
Explain about protocol layer present in SQL server?
Why use “nolock” in sql server?
Can we deploy SSRS reports on our personal website?
What is index in an assignment?
Explain what is the function of sql server agent windows service?
What is the use of nvl work?
How do you manipulate data?