在存储过程的循环中使用Cursor

CREATE PROCEDURE UpdateSalary
AS
BEGIN
    DECLARE @empid INT
    DECLARE @salary DECIMAL(10,2)
    DECLARE @new_salary DECIMAL(10,2)

    DECLARE emp_cursor CURSOR FOR
        SELECT empid, salary FROM employees

    OPEN emp_cursor

    FETCH NEXT FROM emp_cursor INTO @empid, @salary

    WHILE @@FETCH_STATUS = 0
    BEGIN
        SET @new_salary = @salary * 1.10

        UPDATE employees SET salary = @new_salary WHERE empid = @empid

        FETCH NEXT FROM emp_cursor INTO @empid, @salary
    END

    CLOSE emp_cursor
    DEALLOCATE emp_cursor
END