New Transact SQL Video Tutorial: Scalar, System, Built-In and Niladic Functions - What They Are and How to Use Them (SQL Server 2000)

Scalar, System, Built-In and Niladic Functions - What They Are and How to Use Them (SQL Server 2000) - view details

This video focuses on the common scalar functions built into SQL Server 2000 (such as GETDATE(), UPPER(), SUBSTRING(), et al). Scott Whigham, author of this site, walks you through the most commonly used functions and does an excellent job of explaining the different types of functions (such as the cryptic term "Niladic Function").

Highlights from this video:

• Definitions of the terms "Scalar", "Niladic" "System Functions" and more
• How scalar functions work in SQL Server and where/when to use them
• Syntax elements of commonly used functions
• String Manipulation: UPPER(), LOWER(), SUBSTRING()
• Trimming strings
• Commonly used functions in triggers; i.e., Auditing Usage with APP_NAME, DB_NAME, etc
• Overview of User Defined Functions

• Category: The Transact-SQL Language - An Introduction to Common Terms, Tools, and Techniques in TSQL
• Skill Level: 200 (Beginner - Intermediate)
• Length: 7:59 (5.04MB)
• Applies to Versions: SQL Server 2000
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required

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