Lesson 17. Building and Working with User-Defined Functions
SQL Server user-defined functions add power and flexibility slightly different than that available with views and stored procedures. SQL Server user-defined functions accept parameters, perform one or more actions, and return a result. Three types of user-defined functions exist: scalar, inline table-valued, and multi-statement table-valued. The sections that follow cover each of these types of user-defined functions in detail. Used properly, SQL Server user-defined functions enhance your ability to create powerful client/server applications. This lesson covers:
How to create and work ...
Get Sams Teach Yourself T-SQL in One Hour a Day now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
