sql插入临时表数据的方法

create table #Tmp --创建临时表#Tmp
(
    City   varchar(50),  --
    Country  varchar(50),   --
);

insert #Tmp
select ‘北京‘,‘中国‘ union
select ‘东京‘,‘日本‘ union
select ‘纽约‘,‘美国‘ 

select * from #Tmp;

if OBJECT_ID(‘tempdb..#temp‘) is not null
drop table #temp
select * into #temp from 
(
    --select * from Activity
    select 7 as ‘month‘,25 as ‘day‘
    union all
    select 7 as ‘month‘,25 as ‘day‘
    union all
    select 8 as ‘month‘,25 as ‘day‘ 
    union all
    select 8 as ‘month‘,25 as ‘day‘
    union all
    select 8 as ‘month‘,25 as ‘day‘
 
) as A


select *  from #temp