------------恢复内容开始------------
USE [***]--数据库 GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[triTable1Update] ON [dbo].[Table1] AFTER UPDATE AS --if @@rowcount<=1 return BEGIN if update([status]) begin insert into Table1_log select d.id,d.ftype,d.[count],d.mdte,d.mtme,d.status,d.quality,d.errcount,d.rdate,d.rtime,d. remark,d.lmuser,d.pdtype,d.NXTType,d.CQty,d.location,'O',getdate() from deleted d,inserted i where d.id = i.id and d.[status] <> i.[status] insert into Table1_log select i.id,i.ftype,i.[count],i.mdte,i.mtme,i.status,i.quality,i.errcount,i.rdate,i.rtime,i.remark,i.lmuser,i.pdtype,i.NXTType,i.CQty,i.location,'N',getdate() from deleted d,inserted i where d.id = i.id and d.[status] <> i.[status] end END
------------恢复内容结束------------