New features added to SQL Prompt Watch now.

Additional semicolon

edited December 31, 2017 12:52PM in SQL Prompt
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

Answers

Sign In or Register to comment.