Parsing error when building from script folder

AndyIrving

Parse error when doing a compare from script, on this valid syntax:

CREATE PROCEDURE test
AS
;WITH blah (blah)
AS
(
	SELECT 'blah'
)

SELECT * FROM blah

GO

It doesn't like the ';', which isn't required as its the first statement in the batch, but ots also not invalid.

Brian Donahue

Thanks for pointing this out. I have logged a bug with reference SC-4509 to have this looked into. Removing the semicolon does allow the script to be parsed successfully.