CODEWITHSUNDEEP
sqlsql-servercreate-table
Puggy
Puggy

Reputation: 63

Create a table with SQL from Query result in SSMS

I am trying to create a new table from a query result in SSMS

I have tried:

CREATE TABLE table2 AS
(SELECT * FROM table1
 WHERE code = 'x'
 ORDER BY code;)

However I am getting an error telling me:

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

Msg 156, Level 15, State 1, Line 8
Incorrect syntax near the keyword 'ORDER'.

Can anyone help?

Upvotes: 4

Views: 6780

Answers (1)

Galma88
Galma88

Reputation: 2546

Try this:

SELECT * 
INTO NEW_TABLE
FROM table1
WHERE code = 'x'
ORDER BY code;

Upvotes: 4

Related Questions