一个演示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代表游标读取下一条数据是否成功