Steps to use Transact-SQL Cursor

Declare the cursor,
Open the cursor,
Fetch record row by row,
Close cursor,
Deallocate cursor.

Example of a cursor

Declare @EmpId int
Declare curEmp CURSOR READ_ONLY FOR SELECT EmpId FROM Employee
Open curEmp
Fetch next from curEmp into @EmpId
While @@FETCH_STATUS = 0
Begin
          Print @EmpId          
          Fetch next from curEmp into @EmpId
End
Close curEmp
Deallocate curEmp 

<<Previous   Next>>