Export (0) Print
Expand All

SqlUserDefinedAggregateAttribute.IsInvariantToNulls Property

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

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1
© 2015 Microsoft