>Hi,
>
>When DELETE trigger is called, SQL Server creates table DELETED. I want to check that this table (DELETED) has only one record (in my business deleting more than one record indicates a problem). What is the syntax of checking for DELETED having only one record? Thank you.

if (select count(*) from Deleted) = 1
  -- We can proceed - only 1 record