Creating, Altering, and Removing User-Defined Functions [!INCLUDE SQL Server ASDB, ASDBMI, ASDW] The xref:Microsoft.SqlServer.Management.Smo.UserDefinedFunction object provides functionality that lets ...

CLR User-Defined Functions [!INCLUDE SQL Server] User-defined functions are routines that can take parameters, perform calculations or other actions, and return a result.

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

Microsoft’s SQL Server may be a big dog in the enterprise database market, but its conspicuous lack of user-defined functions (UDFs) has stacked up poorly against other leaders of that pack ...

In SQL Server 2014 we saw the introduction of Natively Compiled Stored Procedures. In 2016 we’ll be able to do the same for Scalar User Defined Functions.

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