GO Part 2

  • Anurag-428305

    Old Hand

    Points: 389

    What a Nonsense this question is?:hehe:

  • (Bob Brown)

    SSCrazy

    Points: 2705

    Anurag-428305 (9/20/2012)


    What a Nonsense this question is?:hehe:

    I'm not sure why they made "GO" a configurable batch separator. I'm sure they had a reason that is beyond me but the question is not nonsense in the fact it was something I never knew and even thought about but am aware of now due to this question.

  • Jamie-2229

    SSCrazy Eights

    Points: 8151

    Was it mentioned how one would change the separator?

    Jamie

  • SQL_Hunt

    SSC-Dedicated

    Points: 33267

    The question was not clear at all...at a surface while using 'notgo', the entire script should prone to a failure..

    Thanks.

  • Kenneth.Fisher

    SSCoach

    Points: 19587

    SQL-DBA-01 (10/8/2012)


    The question was not clear at all...at a surface while using 'notgo', the entire script should prone to a failure..

    Please read the explanation and the previous 79 posts. That should explain it quite thoroughly. If not please post again and I'll try to explain it in a different way.

    Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

  • jfgoude

    SSCrazy

    Points: 2586

    no technical interest....just semantic

    I disagree

  • Kenneth.Fisher

    SSCoach

    Points: 19587

    jfgoude (12/21/2012)


    no technical interest....just semantic

    I disagree

    Until you get a script that doesn't work because the author decided they were used to RUN as a batch separator and that's how they have their scripts configured.

    Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

  • batgirl

    SSCarpal Tunnel

    Points: 4979

    Yes, I wanted to complain about the True/False vs. Yes/No...but in all honesty I was easily able to correlate True = Yes and False = No. My problem was that I didn't know about the ability to change the batch separator (in spite of having looked at that very options dialog easily hundreds of times.

    I appreciate the opportunity to learn something that will undoubtedly "stick" with me because of this lively debate 😛

Viewing 8 posts - 76 through 83 (of 83 total)

You must be logged in to reply to this topic. Login to reply