dbo.QBM_TUAssembly_DialogTable

1  create   trigger QBM_TUAssembly_DialogTable on DialogTable  for Update not for Replication as begin declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext
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: if update(InsertValues
3) or update(IsDeactivatedByPreProcessor) or update(OnDiscardedScript) or update(OnDiscardingScript) or update(OnLoadedScript)  or update(OnSavedScript)
4 or update(OnSavingScript) or update(SelectScript) or update(DeleteDelayScript) begin if exists (select top 1 1 from deleted d join DialogTable t on d.UID_DialogTable
5 = t.UID_DialogTable where ( d.IsDeactivatedByPreProcessor <> t.IsDeactivatedByPreProcessor or isnull(d.OnDiscardedScript, '') <> isnull(t.OnDiscardedScript
6, '') or isnull(d.OnDiscardingScript, '') <> isnull(t.OnDiscardingScript, '') or isnull(d.OnLoadedScript, '') <> isnull(t.OnLoadedScript, '')  or isnull
7(d.OnSavedScript, '') <> isnull(t.OnSavedScript, '') or isnull(d.OnSavingScript, '') <> isnull(t.OnSavingScript, '') or isnull(d.SelectScript, '') <> isnull
8(t.SelectScript, '') or isnull(d.DeleteDelayScript, '') <> isnull(t.DeleteDelayScript, '') ) ) begin exec QBM_PDBQueueInsert_Single 'QBM-K-ScriptAssemblyReset'
9, 'Table', '#', @GenProcID  end end if update(IsDeactivatedByPreProcessor) begin declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01
10(Object, SubObject, GenProcID) select distinct 'JobGen', t.TableName , @GenProcID from deleted d join DialogTable t on d.UID_DialogTable = t.UID_DialogTable
11 where ( d.IsDeactivatedByPreProcessor <> t.IsDeactivatedByPreProcessor ) exec QBM_PDBQueueInsert_Bulk 'QBM-K-ScriptAssemblyReset', @DBQueueElements_01
12 end  if update(IsDeactivatedByPreProcessor) begin if exists (select top 1 1 from deleted d join DialogTable t on d.UID_DialogTable = t.UID_DialogTable
13 where ( d.IsDeactivatedByPreProcessor <> t.IsDeactivatedByPreProcessor ) ) begin exec QBM_PDBQueueInsert_Single 'QBM-K-ScriptAssemblyReset', 'Scripts'
14, '#', @GenProcID  end end if update(tablename) or update(IsDeactivatedByPreProcessor) begin exec QBM_PDBQueueInsert_Single 'QBM-K-ScriptAssemblyReset'
15, 'TypedWrappers', '#', @GenProcID end  if update(TableName) or update(UID_DialogTableBase) or update(viewwhereclause) or update(UID_DialogTableUnion) 
16or update(UID_DialogTableBase) or update(IsDeactivatedByPreProcessor) or update(ExtensionForProxyTable) begin  declare @DBQueueElements_02 QBM_YDBQueueRaw
17 insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, @GenProcID from (select i.UID_DialogTable as UID from inserted i union
18 select i.UID_DialogTableBase from inserted i where i.UID_DialogTableBase > ' ' union select i.UID_DialogTableUnion from inserted i where i.UID_DialogTableUnion
19 > ' ' union select d.UID_DialogTable as UID from deleted d union select d.UID_DialogTableBase from deleted d where d.UID_DialogTableBase > ' ' union select
20 d.UID_DialogTableUnion from deleted d where d.UID_DialogTableUnion > ' ' union select t.UID_DialogTable from DialogTable t join deleted d on t.UID_DialogTable
21 = d.UID_DialogTable where ISNULL(t.ExtensionForProxyTable, '') <> isnull(d.ExtensionForProxyTable, '') union select t.UID_DialogTable from DialogTable
22 t join inserted i on t.UID_DialogTableBase = i.UID_DialogTable union select t.UID_DialogTable from DialogTable t join deleted i on t.UID_DialogTableBase
23 = i.UID_DialogTable ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildView', @DBQueueElements_02 end  if update(UID_DialogTableBase) or update(isdeactivatedbypreprocessor
24) or update(DisplayPattern) or update(IsTransportDisabled) or update(isResident) or update(isAssignmentWithEvent) or update(PendingChangeBehavior) begin
25 declare @DBQueueElements_03 QBM_YDBQueueRaw insert into @DBQueueElements_03 (object, subobject, genprocid) select dbo.QBM_FGITableName(x.uid), null, @GenProcID
26 from (select i.UID_DialogTable as UID from DialogTable i join deleted d on i.UID_DialogTable = d.UID_DialogTable where isnull(i.UID_DialogTableBase,''
27) <> isnull(d.UID_DialogTableBase,'') or isnull(i.isdeactivatedbypreprocessor,0) <> isnull(d.isdeactivatedbypreprocessor,0) or isnull(i.DisplayPattern,
28N'') <> isnull(d.DisplayPattern,N'') or isnull(i.IsTransportDisabled,0) <> isnull(d.IsTransportDisabled,0) or isnull(i.isResident, 0) <> isnull(d.isResident
29, 0) or isnull(i.isAssignmentWithEvent, 0) <> isnull(d.isAssignmentWithEvent, 0) or isnull(i.PendingChangeBehavior, 0) <> isnull(d.PendingChangeBehavior
30, 0) union select i.UID_DialogTableBase as UID from DialogTable i join deleted d on i.UID_DialogTable = d.UID_DialogTable where ( isnull(i.UID_DialogTableBase
31,'') <> isnull(d.UID_DialogTableBase,'') or isnull(i.isResident, 0) <> isnull(d.isResident, 0) or isnull(i.isAssignmentWithEvent, 0) <> isnull(d.isAssignmentWithEvent
32, 0) or isnull(i.PendingChangeBehavior, 0) <> isnull(d.PendingChangeBehavior, 0) ) and i.UID_DialogTableBase > ' ' union select d.UID_DialogTableBase as
33 UID from DialogTable i join deleted d on i.UID_DialogTable = d.UID_DialogTable where ( isnull(i.UID_DialogTableBase,'') <> isnull(d.UID_DialogTableBase
34,'') or isnull(i.isResident, 0) <> isnull(d.isResident, 0) or isnull(i.isAssignmentWithEvent, 0) <> isnull(d.isAssignmentWithEvent, 0) or isnull(i.PendingChangeBehavior
35, 0) <> isnull(d.PendingChangeBehavior, 0) ) and d.UID_DialogTableBase > ' ' union  select t.UID_DialogTable from dialogtable t join deleted c on c.UID_DialogTable
36 = t.UID_DialogTableUnion join dialogTable t2 on c.UID_DialogTable = t2.UID_DialogTable   ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeWatchtrigger'
37, @DBQueueElements_03 end if update(viewwhereclause) begin exec QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate', 'QBM-K-CommonRebuildViewR', '', @GenProcID
38 exec QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate', 'QBM-K-CommonRebuildViewU', '', @GenProcID end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd
39 default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 
40