SQL Server User-defined Functions

You organize your data. Now organize your savings.

Set savings goals, track your progress, and stay on course.

Get Savigo for iPhone ›

In this section, you will learn about SQL Server user-defined functions including scalar-valued functions which return a single value and table-valued function which return rows of data.

The SQL Server user-defined functions help you simplify your development by encapsulating complex business logic and make them available for reuse in every query.

• User-defined scalar functions – cover the user-defined scalar functions that allow you to encapsulate complex formula or business logic and reuse them in every query.
• Table variables – learn how to use table variables as a return value of user-defined functions.
• Table-valued functions – introduce you to inline table-valued function and multi-statement table-valued function to develop user-defined functions that return data of table types.
• Removing user-defined functions – learn how to drop one or more existing user-defined functions from the database.