-
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 ...
-
Never put comments on GO line! (reply)
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 ...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|