创建游标

xiaoxiao2021-03-01  13

declare hh cursor scroll for select ee from qq for read only

open hh declare @ee int, @i int set @i=1 fetch next from hh into @ee while (@@FETCH_STATUS<>-1) begin if(@i=3) begin print @ee set @i=0 end fetch next from hh into @ee set @i=@i+1 end

close hh

deallocate hh

declare ss cursor scroll for select cc,ee from qq join zz on qq.ww=zz.ww for update open ss declare @ee int,@cc int fetch next from ss into @cc,@ee while (@@FETCH_STATUS<>-1) begin if(@ee<400 ) begin print @cc update qq set ee=ee+1000000 where current of ss end fetch next from ss into @cc,@ee end close ss deallocate ss

转载请注明原文地址: https://www.6miu.com/read-3350074.html

最新回复(0)