关键字“with"附近的语法不正确...上一条语句必须以分号结尾

2022-01-01 00:00:00 sql common-table-expression sql-server-2005 tsql sql-server

我使用的是 SQL Server 2005.我的存储过程中有 2 个 WITH 子句

Im using SQL Server 2005 . I have 2 WITH Clauses in my stored procedure

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

但是出现错误

关键字with"附近的语法不正确.如果此语句是公用表表达式或 xmlnamespaces 子句，则前面的语句必须以分号结束.

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.

我有哪些选择?有没有我不知道的分离器?

What are my options? Is there any splitter I don't know about?

推荐答案

使用逗号分隔 CTE

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

相关文章