Answer Posted / pawan mothsra
Cursor is a entity in database which is used to fetch data
from database by application by row by row.
Cursor is mainly used for calculation on data on basis of
row by row and you can do transection on another table with
this data row by row basis.
You can use cursor by :-
1.Declare a Cursor
2.OPEN Cursor
3.FETCH and FETCH NEXT Statement
4.CLOSE Cursor
5. Deallocate Cursor
You can take help for .Net, C#, Sql Server, VB.Net Articles
and Interview Questions
("http://www.developerchoice.com")
<a href="http://www.developerchoice.com">DeveloperChoice</a>
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which database stores information about replication?
Explain steps of normalization?
What are the transaction properties?
What guidelines should be followed to help minimize deadlocks?
Which is better statement or preparedstatement?
Which table keeps the locking information?
Why is sql server log file full?
What is bookmark link in ssrs?
What is the purpose of update statistics and scope_identity() function?
What are different type of Collation Sensitivity?
what are triggers? : Sql server database administration
What is a database table?
How to rename an existing column with sql server management studio?
Disadvantages of the indexes?
How do I start sql server 2017?