SQL Server User-defined Functions

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.