GO Part 2
-
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 semanticI 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 7 posts - 76 through 82 (of 82 total)
You must be logged in to reply to this topic. Login to reply