SqlUserDefinedAggregateAttribute::IsInvariantToNulls Property
.NET Framework (current version)
Indicates whether the aggregate is invariant to nulls.
Assembly: System.Data (in System.Data.dll)
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
Available since 2.0
Show: