Types of User-Defined Functions

SQL Server supports three types of user-defined functions:

Scalar functions

Inline table-valued functions

Multistatement table-valued functions

The next few sections take an in-depth look at the differences between the function types and how and where you can use them.

Get Microsoft® SQL Server 2008 R2 Unleashed 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.