跟踪trigger

要先建立好 t_DB_DEPTLog  表 在建立trigger

CREATE TRIGGER [dbo].[t_DB_DEPTLog] ON [dbo].[DB_DEPT]FOR INSERT, UPDATE, DELETEAS    set nocount on    if exists(select * from inserted)        if exists(select * from deleted)                     insert into DB_DEPTLog select * , 'U', system_user, getdate(), host_name() from deleted        else                     insert into DB_DEPTLog select * , 'I', system_user, getdate(), host_name() from inserted       else                     insert into DB_DEPTLog select * , 'D', system_user, getdate(), host_name() from deleted