Back to OIM Explorer

dbo.ATT_TIAttestationPolicy

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on AttestationPolicy. Trigger parent table: AttestationPolicy

Source: sandbox-db sys.sql_modules

Source size: 988 characters

Interpretation

  • Database trigger. Treat parent table and enqueue/object-layer calls as the main relation points.

Relations

  • Trigger parent table: AttestationPolicy

Typed Edges

  • trigger on table AttestationPolicy Trigger parent table: AttestationPolicy
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_PSQLCheckExecutable source text reference

References

Referenced By

Complete Source

SQL46 lines
1CREATE trigger ATT_TIAttestationPolicy2  ON AttestationPolicy FOR3INSERT NOT FOR Replication4AS5BEGIN6  DECLARE @SQLToCheck QBM_YParameterList7  BEGIN TRY8    IF EXISTS(9      SELECT TOP 1 110      FROM inserted)11    GOTO start12    RETURN start:13    DECLARE @GenProcID varchar(38)14    SELECT @GenProcID = dbo.QBM_FGISessionContext('')15    INSERT INTO @SQLToCheck(Parameter1,16    ContentFull)17    SELECT18      c.XObjectKey,19      'select top 1 1 as columnvalue from ' + t.TableName + '20		 where (21		 ' + c.WhereClause + '22		 )'23    FROM inserted c24    JOIN AttestationObject o25      ON c.UID_AttestationObject = o.UID_AttestationObject26    JOIN DialogTable t27      ON o.UID_DialogTable = t.UID_DialogTable28    WHERE29      c.WhereClause > ' '30    UPDATE @SQLToCheck31    SET ContentFull = REPLACE(replace(ContentFull, '@UID_QERPickCategory', '''#'''),32    '@UID_AttestationPolicy',33    '''#''')34    EXEC QBM_PSQLCheckExecutable @SQLToCheck,35      @RaiseError = 136  END TRY37  BEGIN CATCH38    EXEC QBM_PSessionErrorAdd DEFAULT39    RAISERROR('',40    18,41    1)42      WITH NOWAIT43  END CATCH44  endLabel:45  RETURN46END
Open raw exported source
SQL ยท Raw11 lines
1    create   trigger ATT_TIAttestationPolicy on AttestationPolicy  for INSERT not for Replication as begin  declare @SQLToCheck QBM_YParameterList2 BEGIN TRY if exists (select top 1 1 from inserted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext3('')  insert into @SQLToCheck(Parameter1, ContentFull) select c.XObjectKey, 'select top 1 1 as columnvalue from ' + t.TableName + '4		 where (5		 ' +6 c.WhereClause + '7		 )' from inserted c  join AttestationObject o on c.UID_AttestationObject = o.UID_AttestationObject join DialogTable t on o.UID_DialogTable8 = t.UID_DialogTable where c.WhereClause > ' '  update @SQLToCheck set ContentFull = REPLACE (replace(ContentFull , '@UID_QERPickCategory', '''#''') , 9'@UID_AttestationPolicy', '''#''') exec QBM_PSQLCheckExecutable @SQLToCheck, @RaiseError = 1 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR10 ('', 18, 1) WITH NOWAIT END CATCH  endLabel: return end 11