set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO create TRIGGER [dbo].[TRGOnUpdateCheckOUT] ON [dbo].[ChangeCheckOUTTBL] after delete AS BEGIN SET NOCOUNT ON; insert into [ChangeCheckOUTTBL] ([SerialNo] ,[Comment] ,[FK_BankAccount] ,[CheckDate] ,[FK_DocSysCode] ,[OnChangeUserId] ,[OnChangeSysDate] ,[IsUpDated]) select [SerialNo] ,[Comment] ,[FK_BankAccount] ,[CheckDate] ,[FK_DocSysCode], dbo.funuserid(),getdate(),1 from deleted END