MSSQL 使用技巧

1、只复制一个表的结构

select * into [tableName1] from [tableName2] -- 表的复制
select top 0 * into [tableName1] from [tableName2] -- top 0 的妙用

select * into b from a where 1<>1 --where 1<>1