SQL SERVER 遍历表记录_唔咿呀嘿嘿的博客_sqlserver遍历表中记录

declare @docid int ;

set @docid = 1 

--假设表aa中有两条docid = 1 的记录

select distinct docid into #aa from aa where docid = 1 ;

while exists (select docid from #aa )
begin
  set rowcount 1 ;
  update aa set docid = 2 where docid = @docid ;
  set rowcount 0 ;
  
  delete from #aa where docid = @docid ;
end ;

declare @docid int ;

set @docid = 1 

--假设表aa中