T-SQL STOP or ABORT command in SQL Server

sql sql-server tsql sql-scripts
Phillip Senn picture Phillip Senn · Jan 8, 2010 · Viewed 106.3k times · Source

Is there a command in Microsoft SQL Server T-SQL to tell the script to stop processing? I have a script that I want to keep for archival purposes, but I don't want anyone to run it.

Answer

Jed picture Jed · Apr 4, 2012

An alternate solution could be to alter the flow of execution of your script by using the GOTO statement... 

DECLARE  @RunScript bit;
SET @RunScript = 0;

IF @RunScript != 1
BEGIN
RAISERROR ('Raise Error does not stop processing, so we will call GOTO to skip over the script', 1, 1);
GOTO Skipper -- This will skip over the script and go to Skipper
END

PRINT 'This is where your working script can go';
PRINT 'This is where your working script can go';
PRINT 'This is where your working script can go';
PRINT 'This is where your working script can go';

Skipper: -- Don't do nuttin!

Warning! The above sample was derived from an example I got from Merrill Aldrich. Before you implement the GOTO statement blindly, I recommend you read his tutorial on Flow control in T-SQL Scripts.

Related questions

Execute Stored Procedure for List of Parameters in SQL

I have an Stored Procedure that have an argument named Id: CREATE PROCEDURE [TargetSp]( @Id [bigint] ) AS BEGIN Update [ATable] SET [AColumn] = ( Select [ACalculatedValue] From [AnotherTable] ) Where [ATable].[Member_Id] = @Id END So I need to use it for a …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More