Create table emp1 as select * from emp where 1=2;
Error:Msg 156, Level 15, State 1, Line 1<br /> Incorrect syntax near the keyword 'as'.
Select * Into emp1 from emp where 1=2;
SELECT column_name(s) INTO dbo.emp1 FROM dbo.emp WITH(NOLOCK) WHERE 1=1
CREATE TABLE TABLE2 AS SELECT * FROM TABLE1 WHERE 1=2
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)