SQL Server 2008请求关于创建游标以循环遍历记录的示例

-- 创建一个临时表，用于存储示例数据
CREATE TABLE #Employees
(
    EmployeeID INT PRIMARY KEY,
    FirstName NVARCHAR(50),
    LastName NVARCHAR(50),
    Salary DECIMAL(10,2)
)

-- 插入示例数据
INSERT INTO #Employees (EmployeeID, FirstName, LastName, Salary)
VALUES (1, 'John', 'Doe', 5000.00),
       (2, 'Jane', 'Doe', 5500.00),
       (3, 'Alice', 'Johnson', 6000.00),
       (4, 'Bob', 'Smith', 6500.00)

-- 声明游标变量
DECLARE @EmployeeID INT, @FirstName NVARCHAR(50), @LastName NVARCHAR(50), @Salary DECIMAL(10,2)

-- 打开游标
DECLARE EmployeeCursor CURSOR FOR
SELECT EmployeeID, FirstName, LastName, Salary FROM #Employees

OPEN EmployeeCursor

-- 获取记录
FETCH NEXT FROM EmployeeCursor INTO @EmployeeID, @FirstName, @LastName, @Salary

WHILE @@FETCH_STATUS = 0
BEGIN
    -- 在此处执行循环遍历记录的操作
    PRINT 'EmployeeID: ' + CAST(@EmployeeID AS NVARCHAR(10)) + ', FirstName: ' + @FirstName + ', LastName: ' + @LastName + ', Salary: ' + CAST(@Salary AS NVARCHAR(10))

    -- 获取下一条记录
    FETCH NEXT FROM EmployeeCursor INTO @EmployeeID, @FirstName, @LastName, @Salary
END

-- 关闭游标
CLOSE EmployeeCursor
DEALLOCATE EmployeeCursor

-- 删除临时表
DROP TABLE #Employees