Although all Transact-SQL statements are valid within a BEGIN. ... @msg varchar(255) IF (SELECT COUNT(price) FROM titles WHERE title_id LIKE 'BU%' AND ...
technet.microsoft.com