Cursor :-

Insert one table record to another table

DECLARE @rollno varchar(200)

DECLARE @name varchar(200)

DECLARE @MyCursor CURSOR

SET @MyCursor = CURSOR FAST_FORWARD

FOR

SELECT rollno,name

FROM Student1

OPEN @MyCursor

FETCH NEXT FROM @MyCursor

INTO @rollno,@name

WHILE @@FETCH_STATUS = 0

BEGIN

insert into Student2 values(@rollno,@name)

FETCH NEXT FROM @MyCursor

INTO @rollno,@name

END

CLOSE @MyCursor