How can we help you today? How can we help you today?

Parsing error when building from script folder

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.
AndyIrving
0

Comments

1 comment

  • 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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.