Cursor is a database object used by applications to 
manipulate data in a set on a row-by-row basis.

Cursor helps to update, add, select, remove on a row by row
basis on a table

Cursor plays there row quite nicely but although there are 
some disadvantage of Cursor .
Because we know cursor doing roundtrip it will make network 
line busy and also make time consuming methods. First of 
all select query gernate output and after that cursor goes 
one by one so roundtrip happen.Another disadvange of cursor 
are ther are too costly because they require lot of 
resources and temporary storage so network is quite busy.
Site of Dot net and sql server
("http://www.dotnetquestion.info")
<a href="http://www.dotnetquestion.info">link</a>

Work Area used by the SQL statement

The set of rows is returned by SELECT statementb by using 
WHERE clause or not. In our application can not work 
EFFICIENTLY to this result set. If we want to 
access/process the entire block or row or fields or it 
different kind of property, we need the mechanism. This 
mechanism is called CURSOR.

SQL SERVER 2000,

Cursor is a database object used by applications to 
manipulate data in a set on a row-by-row basis.

Cursor helps to update, add, select, remove on a row by row
basis on a table.

A cursor is a mechanism by which you can assign a name to 
a "select statement" and manipulate the information within 
that SQL statement.

We've categorized cursors into the following topics:

1.Declare a Cursor
2.OPEN Statement
3.FETCH Statement
4.CLOSE Statement
5.Cursor Attributes (%FOUND, %NOTFOUND, etc)
6.SELECT FOR UPDATE Statement
7.WHERE CURRENT OF Statement

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>

Cursor is a programming device that allows the SELECT to
find a set of rows but return them one at a time. Cursor
should be used because the host language can deal with only
one row at a time.

you can get unlimited interview questions on:
http://www.interviewhelper.org