December 23, 2007 at 9:23 pm
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.
December 23, 2007 at 10:30 pm
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"
December 23, 2007 at 10:50 pm
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.
December 23, 2007 at 11:30 pm
Just do a SELECT 1/0.... trust me, it'll throw an error
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy