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!

Answer 1

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;

Answer 2

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

Use MyDatabase
Go

SELECT * INTO TestTable FROM dbo.MyTable
GO