在SQL server中使用CTE报错:Incorrect syntax near the keyword ‘with’. If this statement is a common table expression
WITH RowOrder AS
(SELECT [Chart Number] FROM [dbo].[Patient] )
出现这种情况一般在With语句前还有其他的语句,在With前的语句末尾或者With前加上分号;即可
在SQL server中使用CTE报错:Incorrect syntax near the keyword ‘with’. If this statement is a common table expression
WITH RowOrder AS
(SELECT [Chart Number] FROM [dbo].[Patient] )
出现这种情况一般在With语句前还有其他的语句,在With前的语句末尾或者With前加上分号;即可