SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Alter PROCEDURE dbo.TestCursor @arg NVARCHAR(10) --接收参数
AS
BEGIN
IF(@arg='BEGIN')
BEGIN
DECLARE @id INT --定义变量
DECLARE CUR CURSOR --定义游标
FOR SELECT id FROM Nair_fg --结果集
OPEN CUR--打开游标
FETCH NEXT FROM CUR INTO @id --推进
WHILE(@@FETCH_STATUS=0) --开始循环
BEGIN
print(@id) --输出结果集
--UPDATE Nair_fg SET track=@TRACK WHERE CURRENT OF CUR --操作
FETCH NEXT FROM CUR INTO @id --执行完后推进下一条
END
END
CLOSE CUR --关闭游标
DEALLOCATE CUR --释放游标
END
GO
--exec testcursor 'BEGIN'
--SELECT * FROM Nair_fg