游标示例

weixin_30950887

于 2017-06-07 20:18:00 发布

阅读量60

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/peijia/p/6958900.html

DECLARE My_Cursor CURSOR FOR  
    SELECT CellID,TableName FROM [dbo].[tblUpdateInfo]
    OPEN My_Cursor;  
    DECLARE @CellID char(2)
    DECLARE @TableName varchar(50)
    FETCH NEXT FROM My_Cursor INTO @CellID,@TableName;  
    WHILE @@FETCH_STATUS = 0  
       BEGIN  
          PRINT @CellID
          PRINT @TableName
        
          FETCH NEXT FROM My_Cursor INTO @CellID,@TableName;  
       END;  
    CLOSE My_Cursor;  
    DEALLOCATE My_Cursor;