sql插入临时表数据的方法

方法2：直接将查询出来的表数据插入临时表中

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

 欢迎顶....

sql插入临时表数据的方法

标签：image   varchar   blog   count   nbsp   alt   object   img   tmp