Never put comments on GO line!

create procedure mySP as
insert into someTable ....
-- Under SQL Server 2000 the following line will miserably fail!
-- Bug in the parser 2000!
-- processing consists of two stages: parser and engine
-- next line will be passed to engine, which will understand it.
-- the most unexpected diagnostics will follow.
GO -- I was ignorant enough to put comment on the same line as GO...

-- next line of code will be included into the SP above (engine did not
-- understand that the batch above ended)
select from sometable where ...

thanks :)


------------
Alexei Akimov at 1/4/2002 3:37:25 PM

create procedure mySP as
insert into someTable ....
-- Under SQL Server 2000 the following line will miserably fail!
-- Bug in the parser 2000!
-- processing consists of two stages: parser and engine
-- next line will be passed to engine, which will understand it.
-- the most unexpected diagnostics will follow.
GO -- I was ignorant enough to put comment on the same line as GO...

-- next line of code will be included into the SP above (engine did not
-- understand that the batch above ended)
select from sometable where ...