游标的定义供参考
游标定义：
1
DECLARE @SalaryItemID INT
2 DECLARE SalaryItem_Cursor Cursor
3 FOR
4 SELECT SalaryItemID FROM Payroll.SalaryItem WHERE CompanyID=@CompanyID ORDER BY SalaryItemID
5 Open SalaryItem_Cursor
6 Fetch NEXT FROM SalaryItem_Cursor INTO @SalaryItemID
7 While (@@FETCH_STATUS <> -1)
8 BEGIN
9
10 ---执行语句
11
12 Fetch NEXT FROM SalaryItem_Cursor INTO @SalaryItemID
13 END
14 CLOSE SalaryItem_Cursor
15 DEALLOCATE SalaryItem_Cursor
16
DECLARE @SalaryItemID INT 2
DECLARE SalaryItem_Cursor Cursor 3
FOR 4
SELECT SalaryItemID FROM Payroll.SalaryItem WHERE CompanyID=@CompanyID ORDER BY SalaryItemID5
Open SalaryItem_Cursor 6
Fetch NEXT FROM SalaryItem_Cursor INTO @SalaryItemID7
While (@@FETCH_STATUS <> -1)8
BEGIN9
10
---执行语句11
12
Fetch NEXT FROM SalaryItem_Cursor INTO @SalaryItemID13
END14
CLOSE SalaryItem_Cursor15
DEALLOCATE SalaryItem_Cursor16
