How to using T-SQL statement copy table[SQL]

SQL复制表的几种方法：

仅复制表结构：select * into newTableName from OldTableName where 1 = 2

SQL复制整张表 select * into NewTableName from OldTableName

只复制列名而不要内容 select * into NewTableName from OldTableName where 1=0

表间数据复制 insert into Table1(zt) select titile from Table2

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/Fandyx/p/3340844.html