SQL server使用CTE时报错：Incorrect syntax near the keyword ‘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前加上分号;即可