23/02/2015
CURSOR CODE USING SQLSERVER 2012/2008
DECLARE EMPCUR CURSOR FOR SELECT EMPNO, JOB FROM EMP
DECLARE INT, VARCHAR(50)
OPEN EMPCUR
FETCH NEXT FROM EMPCUR INTO ,
WHILE @=0
BEGIN
IF =’PRESIDENT’
UPDATE EMP SET SAL = SAL + SAL * 0.1 WHERE EMPNO=
ELSE IF =’MANAGER’
UPDATE EMP SET SAL = SAL + SAL * 0.08 WHERE EMPNO=
ELSE IF =’ANALYST’
UPDATE EMP SET SAL = SAL + SAL * 0.06 WHERE EMPNO=
ELSE
UPDATE EMP SET SAL = SAL + SAL * 0.05 WHERE EMPNO=
FETCH NEXT FROM EMPCUR INTO ,
END
CLOSE EMPCUR
DEALLOCATE EMPCUR
DECLARE EMPCUR CURSOR FOR SELECT ENAME, SAL FROM EMP
DECLARE VARCHAR(50), MONEY
OPEN EMPCUR
FETCH NEXT FROM EMPCUR INTO ,
WHILE @=0
BEGIN
PRINT ‘SALARY OF ‘ + + ‘ IS ‘ + CAST( AS VARCHAR)
FETCH NEXT FROM EMPCUR INTO ,
END
CLOSE EMPCUR
DEALLOCATE EMPCUR
SET NOCOUNT ON
DECLARE int
DECLARE varchar(50)
DECLARE int
DECLARE cur_emp CURSOR
STATIC FOR
SELECT EmpID,EmpName,Salary from Employee
OPEN cur_emp
IF @ > 0
BEGIN
FETCH NEXT FROM cur_emp INTO ,,
WHILE @ = 0
BEGIN
PRINT 'ID : '+ convert(varchar(20),)+', Name : '++ ', Salary : '+convert(varchar(20),)
FETCH NEXT FROM cur_emp INTO ,,
END
END
CLOSE cur_emp
DEALLOCATE cur_emp
SET NOCOUNT OFF
