O'Reilly logo

Sams Teach Yourself T-SQL in One Hour a Day by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required