Aggregate functions, or Aggregates, perform a calculation on a set of values and return a single value. Traditionally Microsoft® 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 make these functions accessible to Transact-SQL or other managed code.
Aggregate Editor allows you to define aggregate properties. It opens automatically when you create a new aggregate and is available on editing an existing one.
To open an aggregate in Aggregate Editor, double-click it in the DB Explorer tree.
- Using Navigation bar and Toolbar
- Creating/editing aggregate
- Browsing object dependencies
- Editing aggregate description
- Viewing DDL definition
- Setting object permissions