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 are the underflow and overflow behaviors on float literals?
How is sql server used?
Is there any difference between the primary key and unique key?
How to get a list of columns using the "sys.columns" view in ms sql server?
Which are new data types introduced in sql server 2008?
How many types of functions are there in sql server?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
What is transaction server isolation?
What is the datatype of rowid?
What are the 10 characteristics of data quality?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
What are the properties and different types of sub-queries?
Who is the owner of a schema in ms sql server?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions