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:

Image How to create and work ...

Get Sams Teach Yourself T-SQL in One Hour a Day now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.