dbo.ATT_TUAttestationWizardParm

1  create   trigger ATT_TUAttestationWizardParm on AttestationWizardParm for Update not for Replication as begin  declare @ConditionsToCheck QBM_YParameterList
2 BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return start: declare @GenProcID varchar
3(38) select @GenProcID = dbo.QBM_FGISessionContext('') if update(PreProcessorCondition) begin  insert into @ConditionsToCheck (ContentFull) select i.PreProcessorCondition
4 from inserted i exec QBM_PPrePropCheckSyntax @ConditionsToCheck  declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, 
5subobject, genprocid) select x.uid, null, @GenProcID from ( select ao.UID_AttestationWizardParm as uid from deleted i join AttestationWizardParm ao on 
6ao.UID_AttestationWizardParm = i.UID_AttestationWizardParm where isnull(i.PreProcessorCondition, N'') <> isnull(ao.PreProcessorCondition, N'') ) as x exec
7 QBM_PDBQueueInsert_Bulk 'ATT-K-PrepropAttestationWizardParm', @DBQueueElements_01 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR
8 ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
9