put the error on resultset

[RicardoPereira]

Hi,

It is possible put the print error generated by an stored procedure in a resultset?
Something like this:

Stored procedure
----------------

create procedure teste as
select * from nonexistentTabe
if (@@error <> 0)
Print 'Error on statement'


How do i put only the &quot;Error on statement&quot; in a resultset?

Thanks
Ricardo Pereira

 

[mwa]

You could assign the error message to a variable and then select the variable:

Declare @strError varchar(50)
set @strError = &quot;Error on Statement&quot;
select @strError as &quot;Error&quot;

mwa
<><

 

[RicardoPereira]

How do i assign the error to an variable?
should i do
..
if (@@error<>0)
@strError=@@error
select @strError as Error

??
This works??

 

[psprague]

Assign it to a variable first. Any operation sets the @@error intrinsic variable with a new value.

SELECT @error = @@error
IF @error <> 0
--you can return the error as a result set
SELECT @error

--or if you want to raise error
RAISERROR(...)

--in a sp you might want to just return the error
return @error