Results 1 to 2 of 2

Thread: Never put comments on GO line!

  1. #1
    Alexei Akimov Guest

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

  2. #2
    olga Guest

    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
  •