[转]MSSQL CURSOR (游标) 笔记

DECLARE @TMP VARCHAR(15) --定义变量

DECLARE CURSOR_DATA CURSOR FOR SELECT RULENUMBER FROM RULES  --站立游标

OPEN CURSOR_DATA --开启游标

FETCH NEXT FROM CURSOR_DATA INTO @TMP --开始查询
WHILE @@FETCH_STATUS=0 -- 判断是否游标尾
BEGIN
   PRINT @TMP --打印变量 
   --这里放执行的语句 
   FETCH NEXT FROM CURSOR_DATA  INTO @TMP --下一个游标
END
CLOSE CURSOR_DATA -- 关闭游标
DEALLOCATE CURSOR_DATA --销毁游标