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
How do I partition a table in sql server?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
What is difference between join and natural join?
How do you rename a table in sql server?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
What is self contained sub query?
What is the difference between truncate and delete commands?
Can you explain full-text query in sql server?
What is merge replication?
Tell me the difference between clustered and non-clustered index?
What is the use of stored procedure?
What type of Index will get created after executing the above statement?
What is the purpose of the model database?
What is SQL Azure Federations?
Can sql server 2016 run on windows 7?
