Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
A Bug Or a Feature?
Message
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00625610
Message ID:
00625805
Vues:
10
Yes it would be nice if QA parser respected comments but it's not the way it works now.

>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.
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform