Devart Forums

A CTE needs ";" (semicolon) before the "WITH" keyword, in previous version ";" was not required when the "WITH" keyword was first statement in a file or after "GO", this has changed in version 5.4.215.
Now without the semicolon in front of "WITH", the query is not returning anything, no errors are reported and the "Output/General" windows just displays:

Changed database context to 'MyDatabase'.
DML succeeded [0.002s]
Execute succeeded [< 0,001s]

The same query is returning records in SSMS.
Semi-colon insertion (Edit/Advanced/InsertSemicolons) is not inserting semicolons before "WITH" in CTE either, are these bugs?

We will fix this issue in one of the next product builds and will notify you once it's available for downloading.