insert into #tmp
Select * from a
Union all
select * from b
union all
select * from c
union all
select * from d或
Select * into #tmp from a
union all
select * from b
union all
select * from c
union all
select * from d
Select * from a
Union all
select * from b
union all
select * from c
union all
select * from d或
Select * into #tmp from a
union all
select * from b
union all
select * from c
union all
select * from d
insert into #temp
Select * from a
Union
select * from b
union
select * from c
union
select * from d--否则,用union all
Select * into #temp from a
union all
select * from b
union all
select * from c
union all
select * from d
as
Select * from a
Union all
select * from b
union all
select * from c
union all
select * from d
go
insert into #tmp select * from view_1