What are the Steps to use Transact-SQL Cursor ?

Question

Hi What are the steps to use Transact-SQL Cursor ?

Satyapriya Nayak · Answer

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