Why Does SQL Server 2005 Return 'Incorrect syntax near the keyword 'with'' and How Can I Fix It?

Addressing Incorrect Syntax Error Near the 'WITH' Keyword

When encountering the error, "Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon," while using SQL Server 2005, it's often due to an incorrect syntax in your WITH clauses.

To resolve this issue, consider using a comma to separate your CTEs (Common Table Expressions). The correct syntax should look like:

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

Instead of:

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

By separating the CTEs with a comma, you are indicating that they are separate clauses and that the previous statement should be terminated with a semicolon. This modification will resolve the syntax error and allow you to successfully execute your stored procedure.

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