Create a table with SQL from Query result in SSMS

Question

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?

You're looking for INTO ... Select * Into table2 FROM table1 WHERE code = 'x' ORDER BY code — John Cappelletti
– John Cappelletti, Commented Nov 27, 2018 at 15:41
MS SQL server, sorry I'm new to this did not know they were different — Puggy
– Puggy, Commented Nov 27, 2018 at 15:41

Galma88 · Accepted Answer · 2018-11-27 16:16:15Z

4

Try this:

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

answered Nov 27, 2018 at 16:16

Galma88

2,5566 gold badges31 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Puggy Over a year ago

Yes, this is what I applied as provided by John Capelleti earlier above! Thanks!

Collectives™ on Stack Overflow

Create a table with SQL from Query result in SSMS

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related