Home|Products|Doc/UDF|Community|Company

FAQ|Demo|Download

 

    vnovalogo.jpg

This documents provides a comparison between how User Defined Aggregate Functions (UDAFs) are done in VectorStar versus Microsoft SQL Server 2005.

 

yellow.jpg

User-defined Aggregate Functions in VectorSQL vs SQLServer2005

Defining the aggregate function

Defining the aggregate function in SQL Server 2005

In Transact-SQL SELECT statements, you can invoke common language runtime (CLR) user-defined aggregates, subject to all the rules that apply to system aggregate functions. The following additional rules apply: