---

Search posts under SQL Server:

---

SQL Server > User defined functions (UDFs)

In this section we are going to learn about the User defined functions (UDFs) in the SQL server.

User defined functions (UDFs)

SQL Server user-defined functions are set of SQL statements that accept parameters, perform an action, and return the result. The return value can either be a single scalar value or a result set.

There are two types of user defined functions in SQL Server

• Scalar function – the user defined function that returns a single value
• Table-Valued function – the user defined function that returns tabular data

Read posts under SQL Server > User defined functions (UDFs)

1. Create a User defined scalar function
2. Create a Table-valued function
3. Create Multi-statement Table-valued function