CLR user-defined aggregates

Applies to: SQL Server

Aggregate functions perform a calculation on a set of values and return a single value. Traditionally, SQL Server supported only built-in aggregate functions, such as SUM or MAX, that operate on a set of input scalar values and generate a single aggregate value from that set. SQL Server integration with the .NET Framework common language runtime (CLR) now allows developers to create custom aggregate functions in managed code, and to make these functions accessible to Transact-SQL or other managed code.

In this section

The following table lists the articles in this section.

Article Description
Requirements for CLR user-defined aggregates Provides an overview of the requirements for implementing CLR user-defined aggregate functions.
Invoke CLR user-defined aggregate functions Explains how to invoke user-defined aggregates.