sql server复制一张表到另一张表

1. 

select * into db1.dbo.table1 from db2.dbo.table2

https://www.cnblogs.com/yaun1498078591/p/10363965.html

2.

复制表结构

复制数据

https://www.cnblogs.com/net-sky/p/8934102.html