set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[TRGOnUpdateInvoice] ON [dbo].[InvoiceTbl] after update AS BEGIN SET NOCOUNT ON; if update(FK_AccountSysCode) or update(FK_DocsysCode) or update(VisitorSyscode) if exists(select * from deleted where not ArchiveName is null and ArchiveName<>'') raiserror (50209,16,1) else INSERT INTO [ChangeInvoiceTbl] ([CustomerName] ,[FK_AccountSysCode] ,[Comment] ,[InvoiceSerialNo] ,[RecivedDate] ,[DelivaredDate] ,[PaymentDate] ,[InvoiceDate] ,[FK_DocsysCode] ,[ArchiveName] ,[UserNo] ,[InvoiceNo] ,[VisitorSyscode] ,[VisitorPer] ,[VisitorAmount] ,[SysDate] ,[Sign] ,[Type] ,[Amani] ,[OnChangeUserId] ,[OnChangeSysDate] ,[IsUpDated]) select [CustomerName] ,[FK_AccountSysCode] ,[Comment] ,[InvoiceSerialNo] ,[RecivedDate] ,[DelivaredDate] ,[PaymentDate] ,[InvoiceDate] ,[FK_DocsysCode] ,[ArchiveName] ,[UserNo] ,[InvoiceNo] ,[VisitorSyscode] ,[VisitorPer] ,[VisitorAmount] ,[SysDate] ,[Sign] ,[Type] ,[Amani] ,dbo.funuserid() ,getdate() ,1 from deleted END