Throw an error/exception from a function
-
Hi all,
Is it possible for me to throw an exception/error from a function in sql server 2005? if yes, then please let me know the syntax for it.
Thanks,
Roopa.
-
Roopa
You cannot use the standard RAISERROR statement in a function nor can u use the TRY...CATCH construct to throw a error.
How ever you can catch any error in the application that calls your function. In case you want to return a exeception for some validation purpose then you can set a pre-defined value to a variable and return that.
Just curious.. do you really require a function or can u use a procedure for your needs.
"Keep Trying"
-
Hi,
Functions are best suited for my requirement. I use the value returned by a scalar user defined function as a part of
insert into t1 select *, function_f1() from t2.
i cannot use a stored procedure here. however, there is a business validation that I want to do inside the function for which I will have to throw an exception / error.
Please let me know if there is any method to do this or any work around for this...
Thanks,
Roopa.
-
Just do a SELECT 1/0.... trust me, it'll throw an error
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply