T-SQL循环查询结果

DECLARE @i INT = 1;
WHILE @i <= 10
BEGIN
    PRINT @i;
    SET @i = @i + 1;
END;

DECLARE @name NVARCHAR(50);
DECLARE @salary DECIMAL(10,2);

DECLARE cursor_name CURSOR FOR
SELECT name, salary FROM employees;

OPEN cursor_name;
FETCH NEXT FROM cursor_name INTO @name, @salary;

WHILE @@FETCH_STATUS = 0
BEGIN
    PRINT 'Name: ' + @name + ', Salary: ' + CAST(@salary AS NVARCHAR(10));
    FETCH NEXT FROM cursor_name INTO @name, @salary;
END;

CLOSE cursor_name;
DEALLOCATE cursor_name;