/topic/55716&pg=-1&hl=

CREATE TRIGGER [AuditЛицензии] ON [dbo].[Лицензии]
FOR INSERT, UPDATE, DELETE
AS
DECLARE @mod tinyint, @id bigint
SET NOCOUNT ON
IF (SELECT Ch_mode FROM sysAuditMode)=1 //атрибут работы тригера в служебной таблице: 1 - вкл, 0 - выкл (например)
BEGIN
IF ((EXISTS (SELECT * FROM deleted)) AND (not (EXISTS (SELECT * FROM inserted)))) SET @mod=0
IF ((EXISTS (SELECT * FROM inserted)) AND (not (EXISTS (SELECT * FROM deleted)))) SET @mod=1
IF ((EXISTS (SELECT * FROM deleted)) AND (EXISTS (SELECT * FROM inserted))) SET @mod=2
INSERT ActionsAudit (User_Login,Ch_Date ,Mode,Table_Name) VALUES (SESSION_USER,GetDate(),@mod,\'Лицензии\')
SET @id=@@DBTS
INSERT auddelЛицензии SELECT *, @id AS \'Action_Id\' FROM deleted
INSERT audinsЛицензии SELECT *, @id AS \'Action_Id\' FROM inserted
END