INSERT INTO SELECT语句复制表数据
--1.创建测试表 createTABLETable1 ( a varchar(10), b varchar(10), c varchar(10), CONSTRAINT[PK_Table1]PRIMARYKEYCLUSTERED ( a ASC ) ) ON[PRIMARY]
createTABLETable2 ( a varchar(10), c varchar(10), d int, CONSTRAINT[PK_Table2]PRIMARYKEYCLUSTERED ( a ASC ) ) ON[PRIMARY] GO --2.创建测试数据 InsertintoTable1 values('赵','asds','90') InsertintoTable1 values('钱','asds','100') InsertintoTable1 values('孙','asds','80') InsertintoTable1 values('李','asds',null) GO select*fromTable2
--3.INSERT INTO SELECT语句复制表数据 InsertintoTable2(a, c, d) selecta,c,5fromTable1 GO
--4.显示更新后的结果 select*fromTable2 GO --5.删除测试表 dropTABLETable1 dropTABLETable2
2.SELECT INTO FROM语句
语句形式为:SELECT vale1, value2 into Table2 from Table1
SELECT INTO FROM创建表并复制表数据
--1.创建测试表 createTABLETable1 ( a varchar(10), b varchar(10), c varchar(10), CONSTRAINT[PK_Table1]PRIMARYKEYCLUSTERED ( a ASC ) ) ON[PRIMARY] GO
--2.创建测试数据 InsertintoTable1 values('赵','asds','90') InsertintoTable1 values('钱','asds','100') InsertintoTable1 values('孙','asds','80') InsertintoTable1 values('李','asds',null) GO
--3.SELECT INTO FROM语句创建表Table2并复制数据 selecta,c INTOTable2 fromTable1 GO
--4.显示更新后的结果 select*fromTable2 GO --5.删除测试表 dropTABLETable1 dropTABLETable2