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

Incorrect syntax near the keyword #39;with#39;...previous statement must be terminated with a semicolon(关键字“with附近的语法不正确...上一条语句必须以分号结尾)

问题描述

我使用的是 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 ....
)

这篇关于关键字“with"附近的语法不正确...上一条语句必须以分号结尾的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！