Microsoft SQL Server Error: "Incorrect syntax near keyword Select"

Question

Unsure what syntax the error is referring to at this statement :-

Use MyDatabase
CREATE TABLE TestTable 
    AS (SELECT * FROM dbo.MyTable);

Any help is appreciated!

Although that is standard SQL, this is not supported by SQL Server — , Feb 22 '18 at 15:59
@a_horse_with_no_name I didnt realize that standard SQL wasnt supported by SQL Server. Thank you! — mitchmitch24, Feb 22 '18 at 16:02

score 3 · Accepted Answer · answered Feb 22 '18 at 15:57

3

The dbo suggests that you are using SQL Server. The syntax error is that this syntax is not supported.

The equivalent syntax in SQL Server is:

SELECT *
INTO TestTable
FROM dbo.MyTable;

answered Feb 22 '18 at 15:57

Gordon Linoff

score 0 · Answer 2 · answered Feb 22 '18 at 16:13

0

You need to use like below. The one you are using is Oracle syntax.

Use MyDatabase
Go

SELECT * INTO TestTable FROM dbo.MyTable
GO

answered Feb 22 '18 at 16:13

Pawan Kumar

3

Not just Oracle. CTAS (Create Table As SELECT...) is supported by most RDBMs, including Azure. Not sure why it hasn't been introduced into SQL Server yet. Maybe vNext. – Eric Brandt Feb 22 '18 at 16:39

2 Answers2