Parsing error when building from script folder

AndyIrvingAndyIrving Posts: 18
edited July 7, 2009 6:14AM in SQL Compare Previous Versions
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.

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
Sign In or Register to comment.