SqlUserDefinedAggregateAttribute.IsInvariantToNulls Property


The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

Indicates whether the aggregate is invariant to nulls.

Namespace:   Microsoft.SqlServer.Server
Assembly:  System.Data (in System.Data.dll)

public bool IsInvariantToNulls { get; set; }

Property Value

Type: System.Boolean

true if the aggregate is invariant to nulls; otherwise false.

Used by the query processor, this property is true if the aggregate is invariant to nulls. That is, the aggregate of S, {NULL} is the same as aggregate of S. For example, aggregate functions such as MIN and MAX satisfy this property, while COUNT(*) does not.

Incorrectly setting this property can result in incorrect query results. This property is not an optimizer hint; it affects the plan selected and the results returned by the query.

.NET Framework
Available since 2.0
Return to top