dbo.QBM_TUDialogGroup
Database TriggerSQL_TRIGGERSandbox DB
Interpretation
- Database trigger. Treat parent table and enqueue/object-layer calls as the main relation points.
- DBQueue relation detected. Follow the task procedure and referenced-by list for async processing.
Relations
- Bulk DBQueue insert -> QBM-K-CommonPrepropGroup / QBM_ZPrePropGroup at line 6
- Bulk DBQueue insert -> QBM-K-CommonGroupNumber / QBM_ZGroupNumber at line 6
- Bulk DBQueue insert -> QBM-K-CommonGroupPattern / QBM_ZGroupPattern at line 6
- Bulk DBQueue insert -> QBM-K-CommonGroupNumber / QBM_ZGroupNumber at line 10
- Bulk DBQueue insert -> QBM-K-CommonGroupPattern / QBM_ZGroupPattern at line 10
- References QBM_PDBQueueInsert_Bulk
- Trigger parent table: DialogGroup
Typed Edges
- queues DBQueue task QBM_ZPrePropGroup at line 6 Bulk DBQueue insert -> QBM-K-CommonPrepropGroup / QBM_ZPrePropGroup at line 6
- queues DBQueue task QBM_ZGroupNumber at line 6 Bulk DBQueue insert -> QBM-K-CommonGroupNumber / QBM_ZGroupNumber at line 6
- queues DBQueue task QBM_ZGroupPattern at line 6 Bulk DBQueue insert -> QBM-K-CommonGroupPattern / QBM_ZGroupPattern at line 6
- queues DBQueue task QBM_ZGroupNumber at line 10 Bulk DBQueue insert -> QBM-K-CommonGroupNumber / QBM_ZGroupNumber at line 10
- queues DBQueue task QBM_ZGroupPattern at line 10 Bulk DBQueue insert -> QBM-K-CommonGroupPattern / QBM_ZGroupPattern at line 10
- trigger on table DialogGroup Trigger parent table: DialogGroup
- references source dbo.QBM_FGISessionContext source text reference
- references source dbo.QBM_PDBQueueInsert_Bulk source text reference
- references source dbo.QBM_PPrePropCheckSyntax source text reference
- references source dbo.QBM_PSessionErrorAdd source text reference
References
- dbo.QBM_FGISessionContext
- dbo.QBM_PDBQueueInsert_Bulk
- dbo.QBM_PPrePropCheckSyntax
- dbo.QBM_PSessionErrorAdd
Referenced By
- No direct source references extracted.
Complete Source
1CREATE trigger QBM_TUDialogGroup2 ON DialogGroup FOR3UPDATE NOT FOR Replication4AS5BEGIN6 DECLARE @ConditionsToCheck QBM_YParameterList7 DECLARE @XUser nvarchar(64) = object_name(@@procid)8 DECLARE @Xdate datetime = getutcdate()9 BEGIN TRY10 IF EXISTS(11 SELECT TOP 1 112 FROM inserted)13 GOTO start14 IF EXISTS(15 SELECT TOP 1 116 FROM deleted)17 GOTO start18 RETURN start:19 DECLARE @GenProcID varchar(38)20 SELECT @GenProcID = dbo.QBM_FGISessionContext('')21 IF22 UPDATE(PreprocessorCondition)23 BEGIN24 INSERT INTO @ConditionsToCheck(ContentFull)25 SELECT i.PreProcessorCondition26 FROM inserted i27 EXEC QBM_PPrePropCheckSyntax @ConditionsToCheck28 DECLARE @DBQueueElements_01 QBM_YDBQueueRaw29 INSERT INTO @DBQueueElements_01(object,30 subobject,31 genprocid)32 SELECT33 x.uid,34 NULL,35 @GenProcID36 FROM(37 SELECT uid_DialogGroup AS uid38 FROM inserted) AS x39 EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonPrepropGroup',40 @DBQueueElements_0141 END42 IF43 UPDATE(GroupNumber)44 BEGIN45 IF EXISTS(46 SELECT TOP 1 147 FROM deleted d48 JOIN DialogGroup g49 ON g.UID_DialogGroup = d.uid_dialogGroup50 WHERE51 d.groupnumber > 0 AND g.groupnumber > 0 AND d.groupnumber <> g.groupnumber)52 BEGIN53 DECLARE @DBQueueElements_02 QBM_YDBQueueRaw54 INSERT INTO @DBQueueElements_02(object,55 subobject,56 genprocid)57 SELECT58 x.uid,59 NULL,60 @GenProcID61 FROM(62 SELECT g.uid_DialogGroup AS uid63 FROM deleted d64 JOIN DialogGroup g65 ON g.UID_DialogGroup = d.uid_dialogGroup66 WHERE67 d.groupnumber > 0 AND g.groupnumber > 0 AND d.groupnumber <> g.groupnumber) AS x68 EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonGroupNumber',69 @DBQueueElements_0270 EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonGroupPattern',71 @DBQueueElements_0272 UPDATE dialoggroup73 SET groupnumber = 0,74 XDateUpdated = @Xdate,75 XUserUpdated = @XUser76 FROM dialogGroup77 JOIN deleted d78 ON dialogGroup.UID_DialogGroup = d.uid_dialogGroup79 WHERE80 d.groupnumber > 0 AND dialoggroup.groupnumber > 0 AND d.groupnumber <> dialoggroup.groupnumber81 END82 END83 END TRY84 BEGIN CATCH85 EXEC QBM_PSessionErrorAdd DEFAULT86 RAISERROR('',87 18,88 1)89 WITH NOWAIT90 END CATCH91ENDOpen raw exported source
1 create trigger QBM_TUDialogGroup on DialogGroup for Update not for Replication as begin declare @ConditionsToCheck QBM_YParameterList declare2 @XUser nvarchar(64) = object_name(@@procid) declare @Xdate datetime = getutcdate() BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists3 (select top 1 1 from deleted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('') if update(PreprocessorCondition4) begin insert into @ConditionsToCheck (ContentFull) select i.PreProcessorCondition from inserted i exec QBM_PPrePropCheckSyntax @ConditionsToCheck declare5 @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select uid_DialogGroup6 as uid from inserted ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonPrepropGroup', @DBQueueElements_01 end if update(GroupNumber) begin if exists (select7 top 1 1 from deleted d join DialogGroup g on g.UID_DialogGroup = d.uid_dialogGroup where d.groupnumber > 0 and g.groupnumber > 0 and d.groupnumber <> 8g.groupnumber ) begin declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, @GenProcID9 from ( select g.uid_DialogGroup as uid from deleted d join DialogGroup g on g.UID_DialogGroup = d.uid_dialogGroup where d.groupnumber > 0 and g.groupnumber10 > 0 and d.groupnumber <> g.groupnumber ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonGroupNumber', @DBQueueElements_02 exec QBM_PDBQueueInsert_Bulk11 'QBM-K-CommonGroupPattern', @DBQueueElements_02 update dialoggroup set groupnumber = 0 , XDateUpdated = @Xdate , XUserUpdated = @XUser from dialogGroup12 join deleted d on dialogGroup.UID_DialogGroup = d.uid_dialogGroup where d.groupnumber > 0 and dialoggroup.groupnumber > 0 and d.groupnumber <> dialoggroup.groupnumber13 end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 14