Create table as select causes error in SQL Server

Question

It's strange or I am new? Here is a simple create table as select causing an error in SQL Server 2008.

CREATE TABLE [SalesOrderHeader2]
AS
    (SELECT *
     FROM [AW].[sales].SalesOrderHeader)

Error:

Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'as'.

No error in oracle:

create table abc AS 
select * from abc2

@Muhammad , In sql-server-2008 the syntax is different. Oracle syntax cannot be applied here. — Anoop H.N, Feb 09 '17 at 07:09
SQL Server does not support the SQL standard `create table as select`. — , Feb 09 '17 at 07:11
CREATE TABLE [SalesOrderHeader2] AS (SELECT * FROM [SalesOrderHeader]); — Muhammad Nadeem, Feb 09 '17 at 07:12
What about this? is this not follow the SQLSERVER standard syntax? — Muhammad Nadeem, Feb 09 '17 at 07:13

score 6 · Accepted Answer · answered Feb 09 '17 at 07:06

6

SELECT * INTO New_Table 
FROM YourTable

answered Feb 09 '17 at 07:06

Alfaiz Ahmed

This is not needed, I need to create a table / New table. – Muhammad Nadeem Feb 09 '17 at 07:17
you wan't to create a table from Existing Table or Simple a new Table – Alfaiz Ahmed Feb 09 '17 at 07:18
I want to create table with same columns and data the one I have. [old table]. – Muhammad Nadeem Feb 09 '17 at 07:20
Then Muhammad Bro Above Mention Query work for you. It Will Create A New Table with your Desire Name And Also Insert data from Old Table – Alfaiz Ahmed Feb 09 '17 at 07:21
Yes, it works. thanks – Muhammad Nadeem Feb 09 '17 at 07:25
Welcome Big Bro – Alfaiz Ahmed Feb 09 '17 at 07:25

1 Answers1