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