-- 声明一个游标
- DECLARE MyCursor CURSOR
- FOR
-- 打开一个游标
OPEN MyCursor
-- 将游标读取到的值赋给变量, 以供循环里面调用
- DECLARE @Customerid varchar(100)
- FETCH NEXT FROM MyCursor INTO @Customerid
- WHILE @@FETCH_STATUS =0
- BEGIN
- PRINT @Customerid
- FETCH NEXT FROM MyCursor INTO @Customerid
- END
-- 关闭游标
CLOSE MyCursor
-- 释放资源
DEALLOCATE MyCursor
sql server 游标使用模板.
来源: http://www.bubuko.com/infodetail-2906983.html