Hi redgate Team!
Formatting the following code introduces an unneeded semicolon between GO and WITH.
A semicolon before the WITH clause is only needed within the same batch...
CREATE TABLE dbo.Heap
(
col1 int NOT NULL
);
GO
; -- THIS SEMICOLON IS INTRODUCED
WITH cte
AS
(
SELECT 1 AS test
)
SELECT * FROM cte;
GO
Version 9.0.4.3408
Thanks for fixing this!
Torsten
Formatting the following code introduces an unneeded semicolon between GO and WITH.
A semicolon before the WITH clause is only needed within the same batch...
Version 9.0.4.3408
Thanks for fixing this!
Torsten