SQL 创建临时表并导入到新表中

-- 创建临时表，并合并2个表的纪录存在临时表TABLE中

use yyu0315
DROP Table #Table
SELECT Identity(int,1,1) AS ID, Place,HappenTime,FindTime,EndTime,FireArea,
ForestArea,InjuredNum,EconomicLosses,UsedPNum,UsedCarNum,UseFee,Name,Job,CompensationFee,
Fine,SeedNum,DetainedDay,Arrest,Cause,Type,Note,datatime,County,Town,Village into #Table from
(select
r.ID,
r. Place,
r.HappenTime,
r.FindTime,
r.EndTime,
r.FireArea,
r.ForestArea,
r.InjuredNum,
r.EconomicLosses,
r.UsedPNum,
r.UsedCarNum,
r.UseFee,
r.Name,
r.Job,
r.CompensationFee,
r.Fine,
r.SeedNum,
r.DetainedDay,
r.Arrest,
r.Cause,
r.Type,
r.Note,
r.datatime,
r.County,
r.Town,
r.Village
from h_FHistoryRecord r
union all
select
t.ID,
t. Place,
t.HappenTime,
t.FindTime,
t.EndTime,
t.FireArea,
t.ForestArea,
t.InjuredNum,
t.EconomicLosses,
t.UsedPNum,
t.UsedCarNum,
t.UseFee,
t.Name,
t.Job,
t.CompensationFee,
t.Fine,
t.SeedNum,
t.DetainedDay,
t.Arrest,
t.Cause,
t.Type,
t.Note,
t.datatime,
t.County,
t.Town,
t.Village
from FhistoryRecord_temp$ t)
As S
SELECT * FROM #Table

 

--创建temp表，该表与临时表的结构和内容一样
select * into temp from #Table

select * from temp;