SQL: Check Existing Rows Matching A Condition

Sat 15 September 2007, by Seppe "Macuyiko" vanden Broucke

Instead of this:

IF (SELECT COUNT(*) FROM Table1 WHERE ... ) > 0

use this:

IF EXISTS(SELECT * FROM Table1 WHERE ...)

Great tip provided by this article.