sqlsql-servert-sqldbo

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

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!

Solution

  • 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;