Re: After RAISERROR executes next line.

From: Thomas Kejser (thomas_at_kejser.org)
Date: 01/02/05 

Date: Sun, 2 Jan 2005 14:49:54 +0100

Hi Prasanth

If I understand you correctly you want to raise an exception so that the
print statement is NOT executed?. Is this correct?

Yours Sincerely
Thomas Kejser

"Prasanth" <Prasanth@discussions.microsoft.com> wrote in message
news:895177B6-342D-4F65-8D66-4177C56B8F6E@microsoft.com...
> Hello,
>
> I am trying to raise an error in MS SQL Server 2000 using the lines
> if x = 1
> raiserror('Error Message', 10, 1)
> print 'Next Line.'
> But, on execution, it shows the error message and goes to the next line.
> (prints 'Next Line')
> How do I set up the server so that after raising the error, the control
> goes
> to the called program.
>
> Thanks in advance,
> Prasanth

Relevant Pages

  • After RAISERROR executes next line.
    ... I am trying to raise an error in MS SQL Server 2000 using the lines ... But, on execution, it shows the error message and goes to the next line. ...
    (microsoft.public.sqlserver.server)
  • Re: Importing functions that require parameters
    ... As a python module is executed when ... To prohibit execution ... Now the print statement will be executed if you invoke your script from ...
    (comp.lang.python)
  • Re: Whats up with this compiler hint?
    ... The "Raise;" statement will transfer execution to the parent exception handler. ... Even though the function result is already assigned, the execution never reached the end of function block and the function result is never returned. ...
    (comp.lang.pascal.delphi.misc)
  • raise and rescue
    ... Is is possible to raise an exception then rescue it and then go back to ... whereever it was raised and continue with execution? ...
    (comp.lang.ruby)
  • Re: CPU usage of Python interpreter doing empty while loop under XP
    ... > execution and view the state of some variables with print is to ... print statement and learn to use "import pdb; ... This will drop you into a convenient interpreter prompt right in ... to return from the set_tracecall to the calling level). ...
    (comp.lang.python)