Miles Neale (9/19/2012)
joe.wolfe (9/13/2012)
The given answer to this question is "true", but I am not sure this is correct. The "NotGo" throws an error "Incorrect syntax near 'NotGo'" and the variable @test-2 cannot be declared twice the same procedure or batch...What am I missing?I felt the same way about this question. But knowing that you can configure things as suggested is a great thing to know about and avoid. Worth learning and even missing the answer to know.
It may be worth mentioning (and honestly I'm not sure I haven't already as long as this discussion as gotten) that the first time I encountered this was when I received a script from a vendor using a non standard batch separator. I had to struggle to figure out what was wrong. My original purpose for this question was to help show others what can be done. Not so that they can use it, since honestly I don't think they should, but so if someone else makes use of this functionality they can easily work around it.
And lets be honest, I find it a rather interesting piece of SQL trivia.
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]