set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO create TRIGGER [dbo].[TRGOnUpdateBankDetail] ON [dbo].[ChangeBankDetailTbl] after delete AS BEGIN SET NOCOUNT ON; insert into [ChangeBankDetailTbl] ([Fk_DocDetailsyscode] ,[Number] ,[OnChangeUserId] ,[OnChangeSysDate] ,[IsUpDated]) select [Fk_DocDetailsyscode],[Number] , dbo.funuserid(),getdate(),1 from deleted END