In SQL Server, there are three types of user-defined functions:
- Functions that are scalar (Returns A Single Value)
- Table Valued Functions inline (Returns a Table Set and contains a single TSQL query)
- Valued Functions in Multi-Statement Tables (Contains multiple TSQL statements and returns Table Set)
Share a personalized message with your friends.