General information
Forum:
Microsoft SQL Server
I'm sorry, but I guess we're sorta talking past each other in this thread, although it has been very educational for me.
Even if "GO" isn't part of T-SQL, etc., I just thought it strange/silly that QA wants to process it especially since the editor itself recognizes it as a comment (i.e., it was green, which is what threw me off initially). I mean, I can't think of any other situation where something in a comment is handled (rather than ignored). I mean, why can't QA just go "oh, everything from /* to */ is a comment, so I will go on and look for "go"s someplace else..."
No biggie; just a thought. 8-)
John BArone
>GO isn't a part of T-SQL. It's QA command that indicates the end of the batch and tells QA to process it.
>
>>Yes, that is what I got.
>>
>>What my point is (was?) this: that if something is in a comment then it should be ignored, whether I type "go" or "SELECT x..." or "Micky Mouse is my favorite character!" After all, commenting out lines of code is something that every programming language allows you to do, and I really still do think it's strange behavior that the parser tries to interpret what's between /* and */ instead of ignoring it...
>>
>>John Barone
>>
>>
>>>It is a bug, because it is fixed in the service pack (SP)
>>>if u run it after installing the SP then it will not run
>>>and will give u the following error .
>>>
>>>Server: Msg 113, Level 15, State 1, Line 10
>>>Missing end comment mark '*/'.
>>>Server: Msg 170, Level 15, State 1, Line 2
>>>Line 2: Incorrect syntax near '*'.
>>>
>>>As a result , u should remove the 'go' from the comment.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only