Sql 通过ROWCOUNT遍历表

来源:互联网 发布:linux 禁止访问外网 编辑:程序博客网 时间:2024/06/03 17:17
declare   @count int,  @l_new_op_code varchar(20),  @l_prooject_id varchar(20) select  @count=COUNT(*)  from test..tab2while  @count<>0begin   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_idend

0 0
原创粉丝点击