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