SqlUserDefinedAggregateAttribute Class
Assembly: System.Data (in system.data.dll)
'Declaration <AttributeUsageAttribute(AttributeTargets.Class Or AttributeTargets.Struct, AllowMultiple:=False, Inherited:=False)> _ Public NotInheritable Class SqlUserDefinedAggregateAttribute Inherits Attribute 'Usage Dim instance As SqlUserDefinedAggregateAttribute
/** @attribute AttributeUsageAttribute(AttributeTargets.Class|AttributeTargets.Struct, AllowMultiple=false, Inherited=false) */ public final class SqlUserDefinedAggregateAttribute extends Attribute
AttributeUsageAttribute(AttributeTargets.Class|AttributeTargets.Struct, AllowMultiple=false, Inherited=false) public final class SqlUserDefinedAggregateAttribute extends Attribute
Not applicable.
SQL Server creates a user-defined aggregate that is bound to the class definition that has the SqlUserDefinedAggregateAttribute custom attribute. Every user-defined aggregate must be annotated with this attribute.
See "CLR User-Defined Aggregates" in SQL Server 2005 Books Online for more information on user-defined aggregates and examples.
The following example shows the SqlUserDefinedAggregateAttribute attribute for a user-defined aggregate. The aggregate uses custom serialization, has a maximum size of 8000 bytes when serialized, and is invariant to nulls, duplicates, and order.
Imports System Imports System.Data Imports System.IO Imports Microsoft.SqlServer.Server <Serializable(), SqlUserDefinedAggregate(Microsoft.SqlServer.Server.Format.UserDefined, _ IsInvariantToNulls:=True, _ IsInvariantToDuplicates:=False, _ IsInvariantToOrder:=False, _ MaxByteSize:=8000)> _ Public Class Concatenate Implements Microsoft.SqlServer.Server.IBinarySerialize
Windows 98, Windows Server 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.