CREATE TRIGGER trgUPDATE_CLIENTE ON dbo.Clientes FOR UPDATE AS BEGIN INSERT dbo.clientes_audit SELECT ,[TRG_OPERACAO] = 'UPDATE',[TRG_DATA]=GETDATE(),
˓→[TRG_FLAG]='OLD' FROM Deleted INSERT dbo.clientes_audit SELECT ,[TRG_OPERACAO] = 'UPDATE',[TRG_DATA]=GETDATE(),˓→[TRG_FLAG]='NEW' FROM Inserted END;
