SQL EXISTS
SQL EXISTS or NOT EXISTS, That Is the Question
The article provides a detailed overview of the T-SQL IF EXISTS and NOT EXISTS statements. It also explains why EXISTS should be chosen over IN and NOT EXISTS over NOT IN when comparing data sets using subqueries.
(more…)