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

Download a free trial of SQL Backup now

User Defined Function Tips

This video gives you some information about how to structure UDF's, naming UDF's and the proper way to use comments in UDF's - all great tips from Andy Novick, the SQL function man!

Duration:
3 mins 14 secs
Skill Level:
100
Rating:
3.99 out of 5
Publish Date:
January 28, 2009
User Defined Function Tips Watch Video Now  Watch it later!
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
Rhonda on 3/6/2009
Simplistic.

Ameena on 3/6/2009
Very nice

Nate on 3/11/2009
Why will people stop being lazy and document their code!?!

Nate on 3/11/2009
Why will people stop being lazy and document their code!?!

Nate on 3/11/2009
Great video...sorry for the double post.

Julie Breutzmann on 3/12/2009
Nice, basic information that should be used more than it is

Jay Trombly on 3/12/2009
The audio was too low.

Jeff Lebowski on 3/14/2009
IHMO, it is not very good practice to have default values mixed with mandatory parameters. I would move optional parameters to the end of the list.

Stephen Anslow on 3/19/2009
If I ever knew about the "DEFAULT" keyword, I'd completely forgotten about it - thanks for the reminder!

Aaron on 9/8/2009
Nice video basic video. I have seen these issues way too often. On a side note, when I heard "his name is my name too" I almost snarfed coffee all over the keyboard. Not sure how many caught the reference but nicely done

recobasi on 9/9/2009
greatt thanks and thanksss :)

stefe novick on 10/20/2009
good video quality... I'm interrested in which tools were used to produc it.

Andy Warren on 10/21/2009
Stefe, we use Camtasia - great tool. If you're on a budget, look at Camstudio, it's freeware

It is ultimately harmful to prefix a SQL object hame with its object type. "name_comma" is better than "udf_name_comma" as a function name.

James Lawrence on 4/9/2010
Info we ALL need to be reminded of! Like his style of presentation...not hurried, somewhat casual, laid back...nice!



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