dbo.QBM_TIDialogColumn

1   create   trigger QBM_TIDialogColumn on DialogColumn  for Insert not for Replication as begin  declare @ConditionsToCheck QBM_YParameterList declare
2 @XUser nvarchar(64) = object_name(@@procid) declare @Xdate datetime = getutcdate() BEGIN TRY if exists (select top 1 1 from inserted) goto start return
3 start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')  insert into @ConditionsToCheck (ContentFull) select i.PreProcessorCondition
4 from inserted i exec QBM_PPrePropCheckSyntax @ConditionsToCheck  update dialogcolumn set Datatype = dbo.QBM_FCVSchemaDatatypeToIntern(cc.DATA_TYPE, cc.CHARACTER_MAXIMUM_LENGTH
5) , SchemaDataType = cc.DATA_TYPE , schemaDataLen = cc.CHARACTER_MAXIMUM_LENGTH , XDateUpdated = @Xdate , XUserUpdated = @XUser from dialogcolumn c join
6 inserted i on c.uid_dialogcolumn = i.uid_dialogcolumn join DialogTable t on c.UID_DialogTable = t.UID_DialogTable join information_schema.columns cc on
7 cc.table_name = t.TableName and cc.column_name = i.columnname where isnull(i.datatype, 0) <> isnull(dbo.QBM_FCVSchemaDatatypeToIntern(cc.DATA_TYPE, cc.CHARACTER_MAXIMUM_LENGTH
8), 0) or isnull(i.SchemaDataType, '') <> cc.DATA_TYPE or isnull(i.SchemaDatalen, 0) <> isnull(cc.CHARACTER_MAXIMUM_LENGTH, 0)  declare @DBQueueElements_01
9 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from (select uid_dialogColumn as UID from
10 inserted ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonPrepropColumn', @DBQueueElements_01   declare @DBQueueElements_02 QBM_YDBQueueRaw insert into
11 @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, @GenProcID from (select i.UID_DialogColumn as UID from inserted i where i.SplittedLookupSupport
12 > ' ' ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-SplittedLookupFill', @DBQueueElements_02  declare @DBQueueElements_36836 QBM_YDBQueueRaw insert into 
13@DBQueueElements_36836(Object, SubObject, GenProcID) select x.uid, null, @GenProcID from ( select ra.UID_DialogTableParent as uid from inserted t join 
14QBM_VQBMRelationALL ra on t.UID_DialogTable = ra.UID_DialogTableChild union select ra.UID_DialogTableChild from inserted t join QBM_VQBMRelationALL ra 
15on t.UID_DialogTable = ra.UID_DialogTableParent union select t.UID_DialogTable from inserted t ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-MissingDisplayRightFill'
16, @DBQueueElements_36836   declare @DBQueueElements_478459 QBM_YDBQueueRaw insert into @DBQueueElements_478459 (object, subobject, genprocid) select x.uid
17, null, @GenProcID from (select distinct t.TableName as UID from inserted i join DialogTable t on i.UID_DialogTable = t.UID_DialogTable ) as x exec QBM_PDBQueueInsert_Bulk
18 'QBM-K-IndexCreateGenerated', @DBQueueElements_478459  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH
19 end 
20