create table newtablename as select * from tablename where 1=0;是ORACLE里的语法。
在SQLSERVER2000里,如果复制数据和结构用:select * into a from table,只复制结构用SELECT * INTO A FROM TABLE 1=2
create table newtablename as select * from tablename where 1=0;是ORACLE里的语法。
在SQLSERVER2000里,如果复制数据和结构用:select * into a from table,只复制结构用SELECT * INTO A FROM TABLE 1=2