sql 创建临时表并且插入多条数据

最新推荐文章于 2024-08-22 15:32:21 发布

Gavin_路飞

最新推荐文章于 2024-08-22 15:32:21 发布

阅读量2.3w

点赞数 6

分类专栏： SqlServer 文章标签： sql 插入临时表

本文链接：https://blog.csdn.net/xu_guowei/article/details/46804785

版权

SqlServer 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

方法一：


create table #Tmp --创建临时表#Tmp
(
    tar   varchar(50),  --修改后 的 目标值
    res  varchar(50),   --修改前 的 值      
);

insert #Tmp
select '爱尔兰','L7667601' union
select '澳大利亚','L67AU0671' union
select '澳门','7777771' 

select * from #Tmp;
drop table #Tmp;

方法二：

if OBJECT_ID('tempdb..#temp') is not null
drop table #temp
select * into #temp from 
(
    select 7 as 'month',25 as 'salesVolume'
    union all
    select 7 as 'month',25 as 'salesVolume'
    union all
    select 8 as 'month',25 as 'salesVolume' 
    union all
    select 8 as 'month',25 as 'salesVolume'
    union all
    select 8 as 'month',25 as 'salesVolume'
    union all
    select 9 as 'month',25 as 'salesVolume'
    union all
    select 9 as 'month',25 as 'salesVolume'
    union all
    select 9 as 'month',25 as 'salesVolume'
    union all
    select 9 as 'month',25 as 'salesVolume'
) as A


select *  from #temp