SqlServer游标演示demo

一个演示SqlServer游标的demo：

DECLARE @id INT,@name NVARCHAR(50)

DECLARE mycursor CURSOR FOR SELECT TOP 100  id,Nickname FROM dbo.UserInfo--定义游标
OPEN mycursor--打开游标

FETCH NEXT FROM mycursor INTO @id,@name--游标读取一行

WHILE @@FETCH_STATUS=0
BEGIN
PRINT CONVERT(NVARCHAR(50),@id)+''+@name
FETCH next FROM mycursor INTO @id,@name--游标继续往下读取一行
END
CLOSE mycursor--关闭游标
DEALLOCATE mycursor--删除游标

@@FETCH_STATUS=0代表游标读取下一条数据是否成功