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