SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Events
Classes
About Us
Login / Register
Subscribe RSS Feed 

Confio Ignite 8

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.

Duration:
3 mins 9 secs
Skill Level:
100
Rating:
4.16 out of 5
Publish Date:
January 28, 2009
Error Handling with UDF's You must be logged in to view this video.  
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of anovick
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...

References



Comments
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

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

Sneha on 1/3/2011
very informatice...but again pretty fast explaining the concept

MInxia on 7/13/2011
it is ok but i am lost

Amar0009 on 9/8/2011
Great example... Thanks.

Steve Harris on 9/23/2011
very confusing explanation.

1F05990EE7 on 9/23/2011
Excellent short video.

Steve Ingham on 9/23/2011
I did learn about set xact_abort off.

Andrew on 9/23/2011
Good information but the voicing is hard to listen to.

MInxia on 9/23/2011
clear

chandrasekhar on 9/23/2011
useful video

Subir on 9/24/2011
It's good

Subir on 9/24/2011
good one

adityabisoi on 9/25/2011
fds

Curtis Gregson on 9/26/2011
volume too low!

Samrat Sen on 11/1/2011
need to know more on error handling



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions