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.
It doesn't like the ';', which isn't required as its the first statement in the batch, but ots also not invalid.