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
Available since 2.0
Return to top
Show: