游标的定义供参考

游标定义：  

 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

 

转载于:https://www.cnblogs.com/stevenshi/archive/2009/11/24/1609583.html