SQLSERVER触发器内INSERT,UPDATE,DELETE三种状态
CREATE TRIGGER Tri_Product_OrderSnapshot ON [T_Product] for INSERT,UPDATE,DELETE
如IF exists (select * from inserted) and not exists (select * from deleted) 则为 INSERT
如IF exists(select * from inserted ) and exists (select * from deleted) 则为 UPDATE
如IF exists (select * from deleted) and not exists (select * from inserted)则为 DELETE