SQL开发知识：详解SQL游标的用法

类型：

       1.普通游标   只有NEXT操作

       2.滚动游标 有多种操作

1.普通游标

DECLARE @username varchar(20),@UserId varchar(100)
DECLARE cursor_name CURSOR FOR –定义游标
SELECT TOP 10 UserId,UserName FROM UserInfo
ORDER BY UserId DESC
OPEN cursor_name –打开游标
FETCH NEXT FROM cursor_name INTO @UserId,@username –抓取下一行游标数据
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT ‘用户ID：’+@UserId+’ ‘+’用户名：’+@username
FETCH NEXT FROM cursor_name INTO @UserId,@username
END
CLOSE cursor_name –关闭游标
DEALLOCATE cursor_name –释放游标