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
Sql 通过ROWCOUNT遍历表
最新推荐文章于 2017-11-01 21:16:03 发布