What are the Steps to use Transact-SQL Cursor ?

Hi Arun,

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 

Please refer the below links

http://www.jackdonnell.com/articles/SQL_CURSOR.htm

Thanks