Error handling in UDF - I

Tuesday, 2 June 2009

                                                 There's no straight forward way for exception handling in a UDFand programmers often let the caller code to handle the error in such cases.You can still write exception handling blocks in the CLR(The common language runtime) UDFs in SQL server 2005/later.Apart from the giving better performance than T-SQL ,the CLR,allows the programmer to perform funtionality which are not available in T-SQL.Will see how to implement this in the upcoming posts!