INSERT + SELECT 快速插入数据

语法1

Insert INTO table(field1,field2,...) values(value1,value2,...)

语法2

Insert into Table2(field1,field2,...) select value1,value2,... from Table1

（要求目标表Table2必须存在，由于目标表Table2已经存在，所以除了插入源表Table1的字段外，还可以插入常量。）

语法3

SELECT vale1, value2 into Table2 from Table1

（要求目标表Table2不存在，因为在插入时会自动创建表Table2，并将Table1中指定字段数据复制到Table2中。）

语法2 案例

设计表插入
Insert Into CLSMHC(MHC001,MHC002,MHC003,MHC004,MHC005,MHC006,MHC037,MHC043,MHC044)
 
 select
 'PMT005' as MHC001,
  columnCode as MHC002,
  columnName as MHC003,
  'ticketList' as MHC004,
  'system' as MHC005 ,
  RIGHT('00000'+CAST(rowNum  AS nvarchar(50)),5) MHC006,
  tableCode as MHC037,
  'F' as MHC043,
  'F' as MHC044
 from (
select r