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 ...

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 ...

Queries containing user-defined functions (UDFs) are widely used, since they allow queries to be written using a mix of imperative language constructs and SQL, thereby increasing the expressive power ...