GO Part 2

  • What a Nonsense this question is?:hehe:

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

  • Was it mentioned how one would change the separator?

    Jamie

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

    Thanks.

  • 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]

  • no technical interest....just semantic

    I disagree

  • 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]

  • 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 82 (of 82 total)

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