Есть ли более рекомендуемый способ определения типа команды в триггере, чем тестирование таблиц DELETED и INSERTED?
В настоящее время мой подход:
(EXISTS (select 1 from INSERTED) AND NOT EXISTS (select 1 from DELETED)) = INSERT
(EXISTS (select 1 from INSERTED) AND EXISTS (select 1 from DELETED)) = UPDATE
(NOT EXISTS (select 1 from INSERTED) AND EXISTS (select 1 from DELETED)) = DELETE