Types of User-Defined Functions

SQL Server supports three types of user-defined functions:

Image Scalar functions

Image Inline table-valued functions

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