Hi All,

I don't recall exactly how RAISERROR works. Does this command halt
the stored procedure and return to the caller automatically or is a
hard return necessary?

Thanks

On Mon, 19 Jan 2004 18:42:55 -0800, Robert Nurse wrote:

A raiserror will not halt the proc - it behaves like a print statement
with an error code.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html

So, since @@error is set with the value used with RAISERROR, can I
assume that RAISERROR sets the SQLState and NativeErrorCode with the
error value and string used with it?

rnurse (AT) cudbytech (DOT) net (Robert Nurse) writes:

Raiseerror is like a 'warn' call. I normally raiserror and then
return straight afterwards (using the convention that a negative exit
status from the proc means failure, and the exit status is zero minus
the raiserror number).

--
Ed Avis <ed (AT) membled (DOT) com>