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