Sql 通过ROWCOUNT遍历表

declare 
  @count int,
  @l_new_op_code varchar(20),
  @l_prooject_id varchar(20)
 
select  @count=COUNT(*)  from test..tab2

while  @count<>0
begin
   SET ROWCOUNT @count
        select @l_new_op_code=size,@l_prooject_id=name  from test..tab2
   SET ROWCOUNT 0
   
   set @count=@count-1
   print @l_new_op_code+@l_prooject_id
end