Custom Attributes for CLR Routines
The attributes listed can be applied to common language runtime (CLR) routines, user-defined types, and user-defined aggregates that are registered in Microsoft SQL Server. If the attribute is not applied, SQL Server assumes the default value. The attributes listed are defined in the Microsoft.SqlServer.Server namespace.
The SqlUserDefinedAggregate Attribute
The SqlUserDefinedAggregate attribute indicates that the method should be registered as a user-defined aggregate. Every user-defined aggregate must be annotated with this attribute.
For more information, see SqlUserDefinedAggregateAttribute.
The SqlFunction Attribute
The SqlFunction attribute indicates the method should be registered as a function, with the appropriate function attributes set.
For more information, see SqlFunctionAttribute.
The SqlFacet Attribute
The SqlFacet attribute is used to return information about the return type of a user-defined type (UDT) expression.
For more information, see SqlFacetAttribute.
The SqlProcedure Attribute
The SqlProcedure attribute indicates the method should be registered as a stored procedure. This attribute is used only by Visual Studio to register the specified method as a stored procedure automatically; it is not used by SQL Server.
For more information, see SqlProcedureAttribute.
The SqlTrigger Attribute
The SqlTrigger attribute indicates the method should be registered as a trigger.
You can apply the SqlUserDefinedTypeAttribute to a class definition in the assembly. It causes SQL Server to create a user-defined type that is bound to the class definition which has this custom attribute.
For more information, see SqlUserDefinedTypeAttribute.
The SqlMethod Attribute
The SqlMethod attribute is used to indicate the determinism and data access properties of a method or a property on a UDT.
For more information, see SqlMethodAttribute.