SQL中SELECT INTO和INSERT INTO SELECT语句
来源:互联网 发布:php超链接怎么做 编辑:程序博客网 时间:2024/05/21 21:02
1.INSERT INTO SELECT语句
1.创建测试表
create TABLE Table1(
a varchar(10),
b varchar(10),
c varchar(10),
CONSTRAINT [PK_Table1] PRIMARY KEY CLUSTERED
(
a ASC
)
) ON [PRIMARY]
create TABLE Table2
(
a varchar(10),
c varchar(10),
d int,
CONSTRAINT [PK_Table2] PRIMARY KEY CLUSTERED
(
a ASC
)
) ON [PRIMARY]
GO
--2.创建测试数据
Insert into Table1 values('赵','asds','90')
Insert into Table1 values('钱','asds','100')
Insert into Table1 values('孙','asds','80')
Insert into Table1 values('李','asds',null)
GO
select * from Table2
--3.INSERT INTO SELECT语句复制表数据
Insert into Table2(a, c, d) select a,c,5 from Table1
GO
--4.显示更新后的结果
select * from Table2
GO
--5.删除测试表
drop TABLE Table1
drop TABLE Table2
2.SELECT INTO FROM语句
1.创建测试表
create TABLE Table1
(
a varchar(10),
b varchar(10),
c varchar(10),
CONSTRAINT [PK_Table1] PRIMARY KEY CLUSTERED
(
a ASC
)
) ON [PRIMARY]
GO
--2.创建测试数据
Insert into Table1 values('赵','asds','90')
Insert into Table1 values('钱','asds','100')
Insert into Table1 values('孙','asds','80')
Insert into Table1 values('李','asds',null)
GO
--3.SELECT INTO FROM语句创建表Table2并复制数据
select a,c INTO Table2 from Table1
GO
--4.显示更新后的结果
select * from Table2
GO
--5.删除测试表
drop TABLE Table1
drop TABLE Table2
阅读全文
0 0
- SQL中SELECT INTO和INSERT INTO SELECT语句介绍
- SQL中SELECT INTO和INSERT INTO SELECT语句介绍
- SQL中SELECT INTO和INSERT INTO SELECT语句介绍
- SQL中SELECT INTO和INSERT INTO SELECT语句
- [SQL]SELECT INTO 和 INSERT INTO SELECT 两种表复制语句
- sql 语句:SELECT INTO 和 INSERT INTO SELECT 表复制
- SQL中SELECT INTO和INSERT INTO SELECT(复制表)
- insert into ...... select ....sql语句
- SQL中SELECT INTO和INSERT INTO SELECT语句介绍 笔记
- INSERT...SELECT 语句和SELECT...INTO 语句
- sql select into 和insert into
- INSERT INTO SELECT语句 和 SELECT INTO FROM语句
- insert into select 语句
- insert into select 语句
- select ... into ... 与 insert into .... select .... 语句
- select into 和 insert into select 两种表复制语句
- select into 和 insert into select 两种表复制语句
- select into 和 insert into select 两种表复制语句
- java泛型知识总结
- opengl 图像缩放和只画线
- 网站建站流程
- OpenCV3_C++_Laplacian()拉普拉斯滤波处理 实例
- Lumen 查询执行SQL
- SQL中SELECT INTO和INSERT INTO SELECT语句
- android studio 运行coco2dx 的小问题
- ubuntu PJSIP编译java库及jni生成,开放新jni接口
- 打造自己的 APP「冰与火百科」(三):Material Design 控件
- poj 2109
- YII2验证码
- OpenCV3_C++_Sobel()sobel边缘检测 实例
- Androidstudio 出现 Call requires API level 24(current minimum is 15):android.icu.util.calendar 问题时的办法
- 正则表达式总结(二)重复