SQL CURSOR

A cursor is a temporary work area created in the system memory when a SQL statement is executed. A cursor contains information on a select statement and the rows of data accessed by it.

EXAMPLE:

DECLARE @ID int,@Name varchar(50)
DECLARE CursorVar CURSOR LOCAL FOR SELECT ID,Name FROM TABLE 
OPEN CursorVar
    FETCH NEXT FROM CursorVar into @ID,@Name
    WHILE @@FETCH_STATUS = 0
    BEGIN
        SELECT @ID,@Name     
        FETCH NEXT FROM CursorVar into @ID,@Name
    END 
CLOSE CursorVar
DEALLOCATE CursorVar