Error Handling with UDF's

User defined functions have some limitations and quirks when it comes to error handling, and in ways you might not expect! Andy Novick has put together a great illustration of the differences in error handling between stored procedures and user defined functions.

Andrew Novick is a SQL Server consultant building business solutions with the Microsoft tools. His expertise in database design, T-SQL coding, SQL Server security, database performance tuning, and database partitioning can be a valuable asset to many projects. Andrew Novick also offers training and mentoring services to relevant projects. His writing on computing can be seen at his web site ht...

Mark Horninger on 5/1/2009

Good Info!

4F2F0FFB9A on 5/1/2009

Great nugget. Would be even better if an example had been included of the calling code handling the error thrown by the UDF.

Jonathon Moorman on 5/1/2009

interesting vid. i was more curious about these little quick videos than anything else. it was great to get the refresher on xact_abort.

Sneha on 5/1/2009

is useful

Satyabodhi Densmore on 5/1/2009

This illustrates an exceptionally clear method of presentation.

Dennis Allen on 5/1/2009

Question 2, item b stated that the UDF behaves as if SET XACT_ABORT is ON and that is the opposite, so all the above cannot be true.

Santosh Sharma on 5/4/2009

Thank you to give the insight of SP and Functions. These details will make us to understand and write more robust SP and functions.

lisa on 5/5/2009

Difficult to hear the presenter.

995751D667 on 5/5/2009

Very informative info on topic that is not intuitive. Thanks.

Modi, Sanjay on 8/12/2009

Tricky one, provide good understanding

Darren on 9/9/2009

Do not begin a video with "what this does not do" Why not simplify the videos with very basic less complex concepts people can build their skills with. I think video learning is great, keep on!

Tonci on 10/19/2009

Awesome explanation!

Oscar Gras Grazón on 3/30/2010

Tittle doesnt correspond to video objetives

on 5/21/2010

Poor audio....