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
What is exporting utility?
Why use “in” clause in sql server?
How do I open port 1433?
How to make conditional sum in ssrs?
How to create a user name in a database?
What are sql dirty pages?
What is the importance of concurrency control?
What are data driven subscriptions?
Explain steps of normalization?
What is mssql?
Explain what is lock escalation and what is its purpose?
When cursors are useful?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What are various limitations of the views?
What is the sql server 2000 version number?