類型：

       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 –抓取下一行游標數(shù)據(jù)
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT ‘用戶ID：’+@UserId+’ ‘+’用戶名：’+@username
FETCH NEXT FROM cursor_name INTO @UserId,@username
END
CLOSE cursor_name –關閉游標
DEALLOCATE cursor_name –釋放游標