set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[TRGOnDeleteInvoice] ON [dbo].[InvoiceTbl] after delete AS BEGIN SET NOCOUNT ON; 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() ,0 from deleted END