>>>>>>Thank you for the explanation. Now I just need to see some lines of code that, for example, would need to be run in the SSMS and
must have GO.
>>>>>
>>>>>Just comment out each GO in any long script you have, and then wait for SQL to complain :).
>>>>
>>>>I suppose so far I have not done anything that complicated that requires a GO.
>>>
>>>
>>>These:
>>>
>>>UPDATE SomeTable SET ....
>>>
>>>GO
>>>
>>>ALTER/CREATE TRIGGER ...
>>>
>>
>>Thank you, Borislav. Just to clarify, if the line after UPDATE was another UPDATE and not ALTER/CREATE trigger, the GO would not be mandatory, right?
>
>Correct. This is what we started from in this thread, did we not? :)
>
>The CREATE/ALTER PROCEDURE, CREATE/ALTER FUNCTION, CREATE/ALTER TRIGGER commands must be in a single batch. If we want to have them in the same batch, we need to use dynamic SQL.
I didn't connect what you said about Create Procedure with Create/Alter Trigger. I got it now. Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham