1。表結構相同的表，且在同一資料庫（如，table1,table2)Sql ：insert into table1 select * from table2 (完全複製)insert into table1 select distinct * from table2(不複製重覆紀錄）insert i ...
1。表結構相同的表，且在同一資料庫（如，table1,table2)
Sql ：insert into table1 select * from table2 (完全複製)
insert into table1 select distinct * from table2(不複製重覆紀錄）
insert into table1 select top 5 * from table2 (前五條紀錄)
2。 不在同一資料庫中（如，db1 table1,db2 table2)
sql: insert into db1..table1 select * from db2..table2 (完全複製)
insert into db1..table1 select distinct * from db2table2(不複製重覆紀錄）
insert into tdb1..able1 select top 5 * from db2table2 (前五條紀錄)
