简单sql疑问
select * into a from (select * from b) as temp where 1=0

想复制一个b表的表结构，上面的写法是不是会先查出b表的所有数据再判断1=0呢？

[解决办法]
直接select * into #a from b where 1=0
[解决办法]

SQL code

--复制表结构select * into a from b where 1=0
[解决办法]
探讨

直接select * into #a from b where 1=0

[解决办法]
我在二楼的回复呢？

SQL code
-复制表结构直接执行select * into a from b where 1=0