CLR user-defined functions

Applies to: SQL Server

User-defined functions are routines that can take parameters, perform calculations or other actions, and return a result. You can write user-defined functions in any .NET Framework programming language, such as C# or Visual Basic .NET, to use on SQL Server.

There are two types of functions: scalar, which returns a single value, and table-valued, which returns a set of rows.

In this section

The following table lists the articles in this section.

Article	Description
CLR scalar-valued functions	Covers implementation requirements and examples of scalar-valued functions.
CLR table-valued functions	Discusses how to implement and use table-valued functions (TVFs), as well as differences between Transact-SQL and common language runtime (CLR) TVFs.
CLR user-defined aggregates	Describes how to implement and use user-defined aggregates.

Related content

• User-defined functions