SQL Server 表建Trigger

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