declare @int int
select @int=1
declare @cjdata int
declare cur cursor for SELECT cjdata FROM caijidatatemp where wxdid=1
open cur
fetch next from cur into @cjdata
while @@fech_status=0
begin
update caijidatatemp set cjdata=@int where wxdid=1
select @int=@int+1
fetch next from cur into @cjdata
end
close cur
deallocate cur
select @int=1
declare @cjdata int
declare cur cursor for SELECT cjdata FROM caijidatatemp where wxdid=1
open cur
fetch next from cur into @cjdata
while @@fech_status=0
begin
update caijidatatemp set cjdata=@int where wxdid=1
select @int=@int+1
fetch next from cur into @cjdata
end
close cur
deallocate cur
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货