Hugo Kornelis (2/14/2012)

However, it is not true that ;WITH will cause errors when all statements are semicolon terminated. There is no limit to how many semicolons you use and where you place them. The code below, though clearly not recommended coding style, works.

SELECT 1;;;

;;;

;;;WITH x AS (SELECT 1 AS a)

SELECT * FROM x