假如有table1,table2... tablen,而且结构一样 declare @i int,@str varchar(10000) set @i=1 while @i<n begin set @str=@str+' select * from table'+cast(@i as varchar(5))+' union all ' set @i=@i+1 end set @str=@str+' select * from table'+cast(@i as varchar(5)) exec(@str)
declare @i int,@str varchar(10000)
set @i=1
while @i<n
begin
set @str=@str+' select * from table'+cast(@i as varchar(5))+' union all '
set @i=@i+1
end
set @str=@str+' select * from table'+cast(@i as varchar(5))
exec(@str)