sql server批量处理数据，游标使用

最新推荐文章于 2022-11-27 00:03:27 发布

漫步的社会人

最新推荐文章于 2022-11-27 00:03:27 发布

阅读量636

点赞数

分类专栏： sql 文章标签： SQL 游标

本文链接：https://blog.csdn.net/ad13adsa/article/details/82344563

版权

sql 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

DECLARE MyCursor CURSOR FOR     /*定义游标*/
select count(*) as irowno,dls.DLID from DispatchLists dls where dls.DLID in (select dl.DLID from DispatchList dl where (dl.dDate <= '2014-12-31')) group by dls.DLID 

OPEN MyCursor

declare @cc nvarchar(50),@bid nvarchar(50),@cdlcode nvarchar(50) /*定义变量*/
fetch next from MyCursor into @cc,@bid   /*写入数据*/
while @@FETCH_STATUS = 0                 /*开始循环*/
begin
print 'DLID'+@bid
print @cc
	declare TCursor CURSOR FOR
	select irowno,DLID,AutoID from DispatchLists where DLID = @bid
	OPEN TCursor
	declare @cli nvarchar(50),@bidd nvarchar(50),@cid nvarchar(50),@i int=0
	fetch next from TCursor into @cli,@bidd,@cid
	while @@FETCH_STATUS = 0
	begin
	set @i = @i +1
	print @cid
	update DispatchLists set irowno = @i where AutoID = @cid

	fetch next from TCursor into @cli,@bidd,@cid
	end
	close TCursor
	deallocate TCursor

	select @cdlcode = cDLCode from DispatchList where (dDate <= '2014-12-31') And DLID = @bid
    update SaleBillVouchs set iDLsId = @bid where cbdlcode = @cdlcode
fetch next from MyCursor into @cc,@bid
end
close Mycursor
deallocate Mycursor

淘宝小店：给个关注呗