sqlserver for循环

DECLARE @EmployeeID INT;
DECLARE @CurrentSalary DECIMAL(10, 2);

-- 初始化变量
SET @EmployeeID = (SELECT MIN(EmployeeID) FROM Employees);

WHILE @EmployeeID IS NOT NULL
BEGIN
    -- 获取当前员工的薪水
    SELECT @CurrentSalary = Salary FROM Employees WHERE EmployeeID = @EmployeeID;
    
    -- 更新薪水
    UPDATE Employees SET Salary = @CurrentSalary * 1.05 WHERE EmployeeID = @EmployeeID;
    
    -- 移动到下一个员工
    SET @EmployeeID = (SELECT MIN(EmployeeID) FROM Employees WHERE EmployeeID > @EmployeeID);
END

DECLARE @Name NVARCHAR(100);
DECLARE @Salary DECIMAL(10, 2);

-- 定义 CURSOR
DECLARE EmployeeCursor CURSOR FOR
SELECT Name, Salary FROM Employees;

-- 打开 CURSOR
OPEN EmployeeCursor;

-- 获取第一行数据
FETCH NEXT FROM EmployeeCursor INTO @Name, @Salary;

-- 循环处理每一行数据
WHILE @@FETCH_STATUS = 0
BEGIN
    PRINT 'Name: ' + @Name + ', Salary: ' + CAST(@Salary AS VARCHAR(10));
    
    -- 获取下一行数据
    FETCH NEXT FROM EmployeeCursor INTO @Name, @Salary;
END

-- 关闭并释放 CURSOR
CLOSE EmployeeCursor;
DEALLOCATE EmployeeCursor;

DECLARE EmployeeCursor CURSOR FAST_FORWARD FOR
SELECT Name, Salary FROM Employees;

DECLARE @Counter INT = 0;
DECLARE @MaxIterations INT = 100;

WHILE @Counter < @MaxIterations
BEGIN
    -- 执行操作
    SET @Counter = @Counter + 1;
END