Cursors for SQL server2008

Cursors in SQL server2008 include the cursor result set and cursor position, which is the set of rows returned by the definition SELECT statement, the cursor position
is a pointer to a row of this result set
To declare a cursor before using the cursor, define the properties of the Transact-SQL Server, for example, the cursor's scrolling behavior is used to generate the result of the cursor operation
Set of Queries
For example, define a cursor for the Student information table in the Student Performance management system database
Declare Cursor1 Cursor
For SELECT *
From Student information
1. Open the cursor
Open Cursor1
2. Retrieving cursors
FETCH NEXT from Cursor1
While @ @FETCH_STATUS = 0;
Begin
FETCH NEXT from Cursor1
End
3. Close the cursor
Close Cursor1

Cursors for SQL server2008