SQL SERVER中,如何把一个表中的数据导入到另一个表中?
如果两张表字段相同的话:
insert into newtable as select * from oldtable
如果两张表字段不同的话:
insert into newtable(col1,col2,col3...) as select a.col1,a.col2a.col3... from oldtable b
如果两张表字段相同的话:
insert into newtable as select * from oldtable
如果两张表字段不同的话:
insert into newtable(col1,col2,col3...) as select a.col1,a.col2a.col3... from oldtable b