| title | description | ms.custom | ms.date | ms.prod | ms.reviewer | ms.technology | ms.topic | helpviewer_keywords | ms.assetid | author | ms.author | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CLR User-Defined Aggregates | Microsoft Docs |
SQL Server CLR integration allows you to create custom aggregate functions in managed code, which perform a calculation on a set of values and return a value. |
03/14/2017 |
sql |
clr |
reference |
|
bad9b7e8-5967-4afa-8dc8-6d840faf9372 |
rothja |
jroth |
[!INCLUDE SQL Server] Aggregate functions perform a calculation on a set of values and return a single value. Traditionally, [!INCLUDEmsCoName] [!INCLUDEssNoVersion] has 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. [!INCLUDEssNoVersion] integration with the [!INCLUDEmsCoName] .NET Framework common language runtime (CLR) now allows developers to create custom aggregate functions in managed code, and to make these functions accessible to [!INCLUDEtsql] or other managed code.
The following table lists the topics in this section.
Requirements for CLR User-Defined Aggregates
Provides an overview of the requirements for implementing CLR user-defined aggregate functions.
Invoking CLR User-Defined Aggregate Functions
Explains how to invoke user-defined aggregates.