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 the ‘fillfactor’?
How to throw custom exception in Stored Procedure?
How to enter unicode character string literals in ms sql server?
What is normalization and what are the advantages of it?
Is the primary key column of a table an index in ms sql server?
what's sql server? : Sql server database administration
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
How to enter comments in transact-sql statements?
Explain the concept of recursive stored procedure.
How to round a numeric value to a specific precision?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
What is report snapshot in ssrs?
What is the server name for sql management studio?
Why should one not prefix user stored procedures with ‘sp_’?