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
Define primary key?
How to grant a permission in ms sql server using "grant execute" statements?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
How you can add messages to the nt event log from within a stored procedure?
Do you know what is user defined datatypes and when you should go for them?
How can a database be repaired?
What is sql service broker?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
How to view the error log for any specific instance? : sql server database administration
What is surrogate key? : sql server analysis services, ssas
Does order by actually change the order of the data in the tables or does it just change the output?
what stored procedure would you use to view lock information? : Sql server administration
How to connect a database with sql express.?
Define cursor locking
How to generate create procedure script on an existing stored procedure?