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...