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