sql server游标使用示例

--定义declare @id varchar(20);                                --编号declare @names varchar(20);                             --名字declare @sex varchar(20);                               --性别declare @age int;                                       --年龄declare @grade int;                                     --分数declare @class varchar(20);                             --班级--遍历学生表(找到长得帅的哦~   "b.handsome<>0"都是标志长得帅字段的情况)declare my_cursor SCROLL cursor for select id,names,sex,age,grade,class from TabStudent a left join TabMan b on a.id=b.ManId where b.handsome<>0; open my_cursor;                                        --打开游标fetch my_cursor into @names,@sex,@age,@grade,@class;    --取值WHILE (@@fetch_status = 0)begin......(拿到数据进行操作)fetch next from my_cursor into @names,@sex,@age,@grade,@class;--取下条记录endCLOSE my_cursor   DEALLOCATE my_cursor