User-defined table-valued functions (TVFs) return a **table** data type. For an inline table-valued function, there's no function body; the table is the result set of a single SELECT statement. For ...

User-defined functions in SQL Server fall into three categories: scalar functions that return a single value, inline functions that return a table set, and multi-statement functions that return ...

[!INCLUDE SQL Server ASDB, ASDBMI, ASDW] The xref:Microsoft.SqlServer.Management.Smo.UserDefinedFunction object provides functionality that lets users programmatically manage user-defined functions in ...

In SQL Server, a function that returns a single value is known as a “scalar UDF” or “scalar user defined function”. These scalar UDFs are automatically categorized as deterministic or non ...

In addition, developers are able to define SQL Server user-defined types, stored procedures and functions using Common Language Runtime (CLR) languages. SQL Server includes .Net&'s CLR so ...