SQL游标

0.声明变量用于循环

DECLARE @NAME NVARCHAR(100);DECLARE @AGE NVARCHAR(100);

1.声明游标

DECLARE @iCURSOR CURSOR;

2.设置游标

SET @iCURSOR = CURSOR FOR

3.Sql语句

SELECT Name,Age FROM Student WHERE Age > 20

4.打开游标

OPEN @iCURSORFETCH NEXT FROM @iCURSOR INTO @NAME,@AGE

5.while循环

WHILE @@FETCH_STATUS = 0 BEGIN    //do something......    //下一次    FETCH NEXT FROM @iCURSOR INTO @NAME,@AGEEND

6.关闭游标

CLOSE @iCURSOR 

7.释放游标

DEALLOCATE @iCURSOR