Operators & Expressions Set operators in SQL Server 2016 are used to compare rows between input sets. Explore the UNION INTERSECT and EXCEPT set operators the APPLY operator and the basic components of common table expressions.