Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Still confused about use of GO
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01540105
Message ID:
01540260
Views:
27
>>>>>>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 --mandatory
>>>
>>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform