SQL Server CURSOR

 What is a database cursor ?

A database cursor is an object that enables traversal over the rows of a result set. It allows you to process individual row returned by a query.

SQL Server cursor life cycle

These are steps for using a cursor:

DECLARE 

    @Name as NVARCHAR(MAX), 

    @EMP_ID as InT;

DECLARE My_Test CURSOR

FOR SELECT 

        Name, 

        EMP_ID

    FROM 

        EMPLOYEE_MASTER;

OPEN My_Test;

FETCH NEXT FROM My_Test INTO 

    @Name, 

    @EMP_ID;

WHILE @@FETCH_STATUS = 0

    BEGIN

        PRINT @Name +' ' + CAST(@EMP_ID AS varchar);

        

FETCH NEXT FROM My_Test INTO 

            @Name, 

            @EMP_ID;

    END;

CLOSE My_Test;

DEALLOCATE My_Test;