Cursor Part5

declare mycursor CURSOR
FOR SELECT EMPNO,EMPNAME,ESAL,STATUS
FROM EMP
OPEN mycursor
declare @EMPNO INT,@EMPNAME VARCHAR(40),@ESAL VARCHAR(40),@STATUS VARCHAR(10)
FETCH NEXT FROM mycursor INTO @EMPNO,@EMPNAME,@ESAL,@STATUS
WHILE (@@FETCH_STATUS=0)
BEGIN
UPDATE EMP SET ESAL=’3000′,STATUS=’U’ WHERE EMPNO=@EMPNO
FETCH NEXT FROM mycursor INTO @EMPNO,@EMPNAME,@ESAL,@STATUS
END