LearnDevelopment

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