New Transact SQL Video Tutorial: User-Defined Functions (UDFs) - What They Are and How to Use Them (SQL Server 2000)

User-Defined Functions (UDFs) - What They Are and How to Use Them (SQL Server 2000) - view details

User-Defined Functions (UDFs) in SQL Server 2000 are so helpful and are one of Scott Whigham's (author of this site) favorite additions to TSQL. This video walks you through the syntax of the three different types and provides the context for when/where to use each.

Note: This video was shot for SQL Server 2000 but the same concepts apply in SQL Server 2005

Highlights from this video:

• Scalar Functions
• Writing a TRIM() function
• Single-statement (inline) UDFs
• Multistatement UDFs
• Syntax differences between the table-valued functions
• Performance implications of UDFs in the wrong spots

• Category: User-Defined Functions (UDFs) in SQL Server
• Skill Level: 200 (Beginner - Intermediate)
• Length: 15:51 (8.5MB)
• Applies to Versions: SQL Server 2000
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

Note: You must have the TSCC codec installed to view this video