Enum UnionType
The kind of set operation joining two queries. None = 0 and the original
Distinct/All values keep their numeric assignment so existing
serialized values and plan hashes stay stable; the INTERSECT/EXCEPT members are appended.
public enum UnionType
- Extension Methods
Fields
All = 2UNION ALL: all rows from both queries, including duplicates.Distinct = 1UNION: distinct rows from both queries.Except = 5EXCEPT: distinct rows from the first query that are absent from the second.ExceptAll = 6EXCEPT ALL: rows from the first query absent from the second, preserving duplicates.Intersect = 3INTERSECT: distinct rows present in both queries.IntersectAll = 4INTERSECT ALL: rows present in both queries, preserving duplicates.None = 0No set operation; the query is not combined with another.