Why Does SQL Server Throw 'Incorrect Syntax near 'with'' and How Can I Fix It?

Overcoming Error: "Incorrect Syntax near 'with'": Separating CTEs in SQL Server

When working with SQL Server 2005, you may encounter the error "Incorrect syntax near the keyword 'with'." This occurs when multiple WITH clauses are used in a single statement without proper separation.

Specifically, if your statement contains two or more WITH clauses like:

WITH SomeClause1 AS
(
  SELECT ....
)
WITH SomeClause2 AS
(
  SELECT ....
)

you will receive this error. To resolve it, you can use a comma to separate the CTEs:

;WITH SomeClause1 AS
(
  SELECT ....
)
, SomeClause2 AS
(
  SELECT ....
)

By adding a semicolon at the end of the first CTE and separating the subsequent CTEs with commas, you ensure that each CTE is properly terminated. This allows SQL Server to parse the statement correctly and execute it without errors.

The above is the detailed content of Why Does SQL Server Throw 'Incorrect Syntax near 'with'' and How Can I Fix It?. For more information, please follow other related articles on the PHP Chinese website!