SQL语句之Insert
单条插入
INSERT INTO A (col1,col2) VALUES ('v1','v2')
INSERT INTO A(col1,col2) SELECT 'v1','v2'
批量插入
INSERT INTO A(col1,col2) SELECT col1,col2 FROM B --要求A表存在,且与B表字段对应
SELECT col1,col2 INTO TABLE1 FROM TABLE2 --要求TABLE1不存在,会自动创建
INSERT INTO A(col1,col2) SELECT ('v1','v2'),('v3','v4')
返回刚插入行的id
INSERT INTO A (col1,col2) output.inserted.id VALUES ('v1','v2')
INSERT INTO table1 values('v1','v2') select ident_current('table1')
INSERT INTO table1 values('v1','v2') select @@identity
http://www.cnblogs.com/yezhenhan/archive/2011/08/17/2142948.html
https://www.cnblogs.com/hezp/p/16519431.html