Re: Stop execution of script

From: Jacco Schalkwijk (jacco.please.reply_at_to.newsgroups.mvps.org.invalid)
Date: 11/12/04 

Date: Fri, 12 Nov 2004 09:39:30 -0000

The label must be in the same batch as the GOTO, i.e. they can not be
separated by a GO.

If you use osql to run a script, you can exit it by raising an error with
status 127:

RAISERROR('Exiting now', 16, 127)

If you run it in Query Analyzer, that won't work, but you can still abort
execution (and terminate the connection) by raising an error with severity
20 or higher. You need to be a member of the sysadmin role to do this:

RAISERROR('Exiting now', 20,1) 

-- 
Jacco Schalkwijk
SQL Server MVP
"x-rays" <xrays@discussions.microsoft.com> wrote in message 
news:8CC09CCE-DD61-402D-BA19-3D0EBE4D6A24@microsoft.com...
> Thanks responding Uri,
> I tried that too but because of separate batch executions
> the error that raises is:
> A GOTO statement references the label 'EXIT' but the label has not been
> declared.
>
> "Uri Dimant" wrote:
>
>> x-rays
>> Perhaps you want to try GOTO.
>>
>>  If 'a' <> 'b'
>>  begin
>>       print 'not equal'
>>       GOTO exit
>>  end
>>
>> exit:
>> RETURN
>>
>>
>>
>> "x-rays" <xrays@discussions.microsoft.com> wrote in message
>> news:94E9AB19-9C21-4DF9-A23B-2823A5B341DC@microsoft.com...
>> > hello Experts,
>> >
>> > this question might be a dump one but i will ask it anyway.
>> >
>> > I run a script like the following:
>> >
>> > If 'a' <> 'b'
>> > begin
>> >      print 'not equal'
>> >      return
>> > end
>> >
>> > if object_id('MyStoredProcedure') Is not null
>> > drop procedure MyStoredProcedure
>> > GO
>> >
>> > CREATE Procedure MyStoredProcedure
>> >
>> > AS
>> > set nocount on
>> > select 'something'
>> > set nocount off
>> > GO
>> >
>> > So because a and b is not obviously equal I need the script to stop, 
>> > but
>> > because of GOs (separates executions) script will continue. Is there 
>> > any
>> way
>> > to stop it at the point I  want without using dynamic sql?
>> >
>> > Thanks in advance!
>>
>>
>>

Relevant Pages

  • Re: On Local Error Goto Somewhere
    ... an EXIT DO or EXIT FOR. ... going if there is no label to show you the destination. ... IMO the GoTo statement has never been "THE" problem. ... ON ERROR GOTO MySubErr Dim lFNbr as long ...
    (microsoft.public.vb.general.discussion)
  • Re: Stop execution of script
    ... A GOTO statement references the label 'EXIT' but the label has not been ... >> set nocount off ...
    (microsoft.public.sqlserver.programming)
  • Re: Perform loop enhancements
    ... >> simplicity. ... If you have two different types of your exit ... >> why not use a GOTO? ... Ranting about the label ...
    (comp.lang.cobol)
  • Re: Is David Fenton right about error handling? (re-post?)
    ... > Error Goto 0 a proper termination. ... after the Exit Function. ... Clears all property settings of the Err object. ... Exit Sub, Exit Function, Exit Property ...
    (comp.databases.ms-access)
  • Tail recursion syntactic sugar faked with TAGBODY-based construct?
    ... and provide a GOTO that takes argument expressions. ... in which a a label parameter is shadowed, ... (let (labels forms thunks thunk-gensyms) ... vars gensyms)) ...
    (comp.lang.lisp)