use of raiserror

[mp89]

I want to raise an error in my stored procedure and then have the code go to a specific part of the sproc to deal with errors before exiting. Is this the right way to go about doing this?

e.g.

if (condition)
begin
rollback tran
raiserror
goto on_error
end

--other stuff

on_error:
set @result = 0
return @result


Cheers,

Mike

 

[mrdenny]

That should work for you, assuming that you raise the correct severity level so that the batch doesn't stop executing. You'll need the correct syntax for Raiserror of course.

Denny

--Anything is possible. All it takes is a little research. (Me)