[RESOLVED] create table syntax - mssql 2008 r2

[abhijit]

Is this syntax no longer valid?

CREATE TABLE MYTABLE AS SELECT * FROM ANOTHER_TABLE;

i am pretty certain it works in oracle8i and upwards. It doesn't work in MSSQL.

The syntax that works in MSSQL is

SELECT * INTO MYTABLE from ANOTHER_TABLE

is there one more way to do this in SQL Server 2008?