Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to end the script
Message
General information
Forum:
Microsoft SQL Server
Category:
Scripting
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01323190
Message ID:
01323226
Views:
10
>>>>I want to end the script at some point so the code after it does not run. I would just use CANCEL or RETURN in Forpro.
>>>
>>>Put GO statement to separate scripts from one another. It doesn't stop it, though, so you can use RETURN command.
>>
>>If GO doesn't stop the script, what does it do?
>
>GO is a batch separator and should be used ONLY in query window. You can't have GO inside Stored procedure or in script you sent from your FronEnd.
>I'm not sure what you need here. If you want to execute only several lines from your script in query window just mark them and then execute selection. In other cases you have to put some error handling or additional logic to skip execution. If this is a SP you can have RETURN everywhere you need and that will stop execution of the lines follow that RETURN.

Or block stuff you want or don't want to run in IF..EndIf statements and handle accordingly?
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform