Friday, June 14, 2013

SQL - Check Multiple Tables For Data (IF NOT EXISTS) in a Single IF Statement

Question:  How do you check for existence (IF EXISTS or IF NOT EXISTS) of data across multiple tables in a single if statement in SQL?

Answer:
IF NOT EXISTS (SELECT 1 FROM Table1) AND NOT EXISTS (SELECT 1 FROM Table2) AND NOT EXISTS (SELECT 1 FROM Table3)
BEGIN
PRINT 'DATA DOES NOT EXIST'
END
ELSE
BEGIN
PRINT 'DATA DOES EXIST'
END