How to throw exception from SQL server 2005 function?

Question

When I try to use RaiseError, I get the following compilation issue

Msg 443, Level 16, State 14, Procedure ConvertSessionToCurr, Line 19 Invalid use of a side-effecting operator 'RAISERROR' within a function.

So how do we handle exception in a function/ Change it to a out param stored proc? That really sounds like a bummer!

You could have the function return NULL if an error occurs, depending upon what your application does with the function. — Sparky
– Sparky, Commented Oct 17, 2011 at 3:45

gbn · Accepted Answer · 2011-10-17 04:30:57Z

5

Options:

My thought is that if you need RAISERROR in a UDF you're using it wrong...

answered Oct 17, 2011 at 4:30

gbn

434k84 gold badges602 silver badges690 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

My thought is that if you need RAISERROR in a UDF you're using it wrong...? Serious!

If you return a null or specific sentinel value, how do you pass the error code back to the caller?