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

Scalar, System, Built-In and Niladic Functions - What They Are and How to Use Them - view details

There are far too many SQL functions to list here but what is important is what they are, what the difference is between them, and how you could/should use them. What's the difference between Niladic and Deterministic? Is GETDATE() Deterministic or Non-Deterministic? Is RAND() guaranteed to return a random number? Is NEWID() allowed as a parameter to other functions? If you haven't heard terms like Niladic or Deterministic before then you'll really appreciate this video. Also, SQL guru Scott Whigham gives an excellent breakdown of some common functions

---

• Source: SQL Server videos
• Category: Transact-SQL Basics: Queries, Stored Procedures, Functions and more
• Skill Level: 200 (Beginner - Intermediate)
• Length: 8:00 (5.05MB)
• 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

---

Keywords Associated with this video: udfs, udf, deterministic