set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: Name -- Create date: -- Description: -- ============================================= ALTER TRIGGER [dbo].[TRGOnDeleteDoc] ON [dbo].[DocTbl] 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 ChangeDocTbl (SysCode, DocDate, SysDate, UserIDNO, Comment, ArchiveName, Lock ,OnChangeUserId,OnchangeSysDate,IsUpdated) select SysCode, DocDate, SysDate, UserIDNO, Comment, ArchiveName, Lock,dbo.funuserid(),getdate(),0 from deleted END