一个嵌套游标的例子

最新推荐文章于 2019-01-14 00:02:21 发布

最新推荐文章于 2019-01-14 00:02:21 发布 · 194 阅读

本文提供了一个使用T-SQL进行数据批量更新的具体示例。通过游标遍历满足条件的数据记录，并更新相应的用户信息。该过程展示了如何在SQL Server中实现复杂的业务逻辑。

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