这样? declare @i int select @i=10 while @i>0 begin select * from tablename --这里产生多表结果 set @i=@i-1 end还是:
用临时表 create procedure ... as begin .... if object_id('tempdb..#') is not null drop table # while @i > 0 begin if object_id('tempdb..#') is null select * into # from tablename else insert into # select * from tablename set @i = @i - 1 end .... --最后 select * from # drop table # end
declare @i int
select @i=10
while @i>0
begin
select * from tablename --这里产生多表结果
set @i=@i-1
end还是:
create procedure ...
as
begin
....
if object_id('tempdb..#') is not null drop table #
while @i > 0
begin
if object_id('tempdb..#') is null
select * into # from tablename
else
insert into # select * from tablename
set @i = @i - 1
end
....
--最后
select * from #
drop table #
end