Check if a SQL Select statement returns no rows

To find out whether no matching rows exist you can use NOT EXISTS. Which can be more efficient than counting all matching rows

IF NOT EXISTS(SELECT * FROM ...)
BEGIN
PRINT 'No matching row exists'
END