sql server 游标使用

DECLARE @stuId NVARCHAR(20) --声明变量 DECLARE @stuName NVARCHAR(20)DECLARE userCur CURSORFOR    SELECT  [User_Name] ,            [User_Pwd]    FROM    dbo.T_baseSys_User --声明游标OPEN userCur --打开游标FETCH NEXT FROM userCur INTO @stuId, @stuName --取，填充WHILE @@FETCH_STATUS = 0    BEGIN         PRINT 'ID:' + @stuId + '用户名' + @stuName                FETCH NEXT FROM userCur INTO @stuId, @stuName    END CLOSE userCur --关闭游标DEALLOCATE userCur --释放游标