類型：

       1.普通游標(biāo)   只有NEXT操作

       2.滾動(dòng)游標(biāo) 有多種操作

1.普通游標(biāo)

DECLARE @username varchar(20),@UserId varchar(100)
DECLARE cursor_name CURSOR FOR –定義游標(biāo)
SELECT TOP 10 UserId,UserName FROM UserInfo
ORDER BY UserId DESC
OPEN cursor_name –打開游標(biāo)
FETCH NEXT FROM cursor_name INTO @UserId,@username –抓取下一行游標(biāo)數(shù)據(jù)
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT ‘用戶ID：’+@UserId+’ ‘+’用戶名：’+@username
FETCH NEXT FROM cursor_name INTO @UserId,@username
END
CLOSE cursor_name –關(guān)閉游標(biāo)
DEALLOCATE cursor_name –釋放游標(biāo)