Cursor in sql server

Simple cursor example


Declare @Lastname varchar(50)
DECLARE @Email varchar(20)

DECLARE Student_cursor CURSOR FOR

Select Firstname,Lastname,Email from student

OPEN Student_cursor;

FETCH NEXT FROM Student_cursor
INTO @Firstname, @Lastname, @Email;

WHILE @@FETCH_STATUS = 0
BEGIN
print '---------------'
print @Firstname
print @Lastname
print @Email
print '---------------'
FETCH NEXT FROM Student_cursor
INTO @ItemID;
END

CLOSE Student_cursor;
DEALLOCATE Student_cursor;

Refer this 

http://queriesinsql.blogspot.com/2011/12/cursor-in-sql-with-example.html