Share via

SqlUserDefinedAggregateAttribute.IsInvariantToNulls Property

  • Reference

Definition

Namespace:
Microsoft.Data.SqlClient.Server
Assembly:
Microsoft.Data.SqlClient.dll
Package:
Microsoft.Data.SqlClient v1.0.19269.1
Package:
Microsoft.Data.SqlClient v1.1.4
Package:
Microsoft.Data.SqlClient v2.0.1
Package:
Microsoft.Data.SqlClient v2.1.4
Package:
Microsoft.Data.SqlClient v3.0.1
Package:
Microsoft.Data.SqlClient v3.1.0
Package:
Microsoft.Data.SqlClient v4.0.1
Package:
Microsoft.Data.SqlClient v4.1.0

Indicates whether the aggregate is invariant to nulls.

public:
 property bool IsInvariantToNulls { bool get(); void set(bool value); };
public bool IsInvariantToNulls { get; set; }
member this.IsInvariantToNulls : bool with get, set
Public Property IsInvariantToNulls As Boolean

Property Value

Boolean

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

Remarks

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.

Applies to