Member of the
LearnItFirst.com Video Training Network
Related Video Training Sites:
·
SQL Server DBA Tutorials
·
Integration Services Training
Create a free account
·
Sign In
Transact SQL Videos in Series
Home
Subscriber Videos
Working with User-Defined Functions - An Overview (Video Series)
Video Category:
User-Defined Functions (UDFs) in SQL Server
Skill Level:
300 (Intermediate)
Versions/Editions Covered:
SQL Server 2005
,
SQL Server 2000
,
SQL Server 2008
This video series gives complete coverage of the three types of UDFs: scalar, inline, and multi-statement UDFs. It features discussions of using scalar functions, performance tuning your function usage, and even a very interesting technique for captilization (CamelCase or Camel Case given an input of 'CAMEL CASE' or 'camel case').
Videos in this Series:
Title
Skill
Length
Download
Pt. 1 - An Overview of the Three Types of User Defined Functions (UDFs)
300
11 mins.
Download
Pt. 2 - Working with Scalar-Valued UDFs
300
12 mins.
Download
Pt. 3a - A Scalar-Valued UDF for Working with Propert Case and CamelCase
400
13 mins.
Download
Pt. 3b - Performance and Our CamelCase Function
400
11 mins.
Download
Pt. 4 - Writing Inline UDFs and Multi-Statement UDFs
300
11 mins.
Download
Miscellaneous Bits & Pieces:
Keyboard Shortcut for SQL Server Management Studio: CTRL+SHIFT+L converts text to lowercase
SQL Server 7.0 was the first time that SQL Server supported bullable BIT data types. Previous versions could only be 1 or 0
Helpful Keyboard Shortcuts: "F2" allows you to rename the highlighted/selected item
About Us
·
Corporate Philosophy
·
Become an Author
·
Contact Us
Video Playback
·
System Requirements
·
TSCC Codec
(to play videos)
·
Troubleshooting/Problems
Subscriptions
·
Pricing/Buy Now
·
Testimonials
·
Privacy
·
Terms of Service
More Video Training
·
SQL Server DBA Tutorials
·
Integration Services Training
·
All of Our Websites
More
·
FAQs
·
Search for videos
·
Site Map
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation.
1/8/2009 2:58:49 PM