正确的语句是
insert into table2 ( select * from table1);这要求table2和table1的字段类型且顺序相同,若不同可以将要插入的字段写出来insert into table2 ( a2, b2, c2)
( select a1, b1, c1 from table1);
insert into table2 ( select * from table1);这要求table2和table1的字段类型且顺序相同,若不同可以将要插入的字段写出来insert into table2 ( a2, b2, c2)
( select a1, b1, c1 from table1);
insert into table2 select * from table1;
反之
insert into table2 (col1,col2,...) (select col1,col2,.. from table1);不存在表table2:
create table table2 as select * from table2;
敢问老兄,是不是SQL server用多了?!