一个嵌套游标的例子

declare @class varchar(30)
declare classcursor cursor for
select class from cmrtxl19.qifei.class where cmrtxl19.qifei.class.class like '%北京0609%'
open classcursor
fetch next from classcursor into @class
while ( @@fetch_status=0 )
begin
print @class
declare @username varchar(30)
declare @userid varchar(30)
declare classcursor_2 cursor for
select 姓名,用户名 from pubs.qifei.bj0609fenban where 序号 is null and 班级名称=@class
open classcursor_2
fetch next from classcursor_2 into @username,@userid
declare @i int
set @i=1
while ( @@fetch_status=0)
begin
print '----'+@username+@userid
if @i=1
begin
update cmrtxl19.qifei.class set adm = @username,admid = @userid
where cmrtxl19.qifei.class.class = @class
end
else
begin
update cmrtxl19.qifei.class set adm2 = @username,adm2id = @userid
where cmrtxl19.qifei.class.class = @class
end
set @i=@i+1
if @i=3
begin
break
end
fetch next from classcursor_2 into @username,@userid
end
close classcursor_2
deallocate classcursor_2
fetch next from classcursor into @class
end
close classcursor
deallocate classcursor