Back to OIM Explorer

dbo.ARS_TATTUADSAccount

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on ADSAccount. Trigger parent table: ADSAccount

Source: sandbox-db sys.sql_modules

Source size: 1.202 characters

Interpretation

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

Relations

  • Trigger parent table: ADSAccount

Typed Edges

  • trigger on table ADSAccount Trigger parent table: ADSAccount
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QER_PITShopHelperFill source text reference
  • references source dbo.QER_PITShopHelperFill_Recalc source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL65 lines
1CREATE trigger dbo.ARS_TATTUADSAccount2  ON ADSAccount FOR3UPDATE NOT FOR replication4AS5BEGIN6  DECLARE @GenProcID varchar(38)7  DECLARE @ErrorMessage nvarchar(4000)8  DECLARE @ErrorSeverity int9  DECLARE @ErrorState int10  DECLARE @ret int11  IF EXISTS(12    SELECT TOP 1 113    FROM inserted)14  GOTO start15  IF EXISTS(16    SELECT TOP 1 117    FROM deleted)18  GOTO start19  GOTO endLabel start:20  BEGIN TRY21    IF22    UPDATE(UID_Person)23    BEGIN24      DECLARE @RecalcParameter_01 QBM_YCursorBuffer25      INSERT INTO @RecalcParameter_01(ObjectKey1,26      UID1,27      Ident1)28      SELECT29        'irgendwas',30        'ARS-AttestationRule-PA',31        'A'32      EXEC QER_PITShopHelperFill_Recalc @RecalcParameter_01,33        @GenprocID34      DECLARE @RecalcParameter_02 QBM_YCursorBuffer35      INSERT INTO @RecalcParameter_02(ObjectKey1,36      UID1,37      Ident1)38      SELECT39        p.ObjectKey,40        'ARS-AttestationRule-KA',41        'A'42      FROM(43      SELECT per.XObjectKey AS ObjectKey44      FROM person per45      JOIN inserted i46        ON per.UID_Person = i.UID_Person47      UNION all48      SELECT per.XObjectKey AS ObjectKey49      FROM person per50      JOIN deleted d51        ON per.UID_Person = d.UID_Person) p52      EXEC QER_PITShopHelperFill_Recalc @RecalcParameter_02,53        @GenprocID54    END55  END TRY56  BEGIN CATCH57    EXEC QBM_PSessionErrorAdd DEFAULT58    RAISERROR('',59    18,60    1)61      WITH NOWAIT62  END CATCH63  endLabel:64  RETURN65END
Open raw exported source
SQL ยท Raw9 lines
1 create   trigger dbo.ARS_TATTUADSAccount on ADSAccount  for update not for replication as begin  declare @GenProcID varchar(38) declare @ErrorMessage2 nvarchar(4000) declare @ErrorSeverity int declare @ErrorState int declare @ret int   if exists (select top 1 1 from inserted) goto start if exists (select3 top 1 1 from deleted) goto start goto endLabel start: BEGIN TRY if update(UID_Person) begin    declare @RecalcParameter_01 QBM_YCursorBuffer insert into4 @RecalcParameter_01 (ObjectKey1, UID1, Ident1) select 'irgendwas', 'ARS-AttestationRule-PA', 'A' exec QER_PITShopHelperFill_Recalc @RecalcParameter_015, @GenprocID declare @RecalcParameter_02 QBM_YCursorBuffer insert into @RecalcParameter_02 (ObjectKey1, UID1, Ident1) select p.ObjectKey, 'ARS-AttestationRule-KA'6, 'A' from (select per.XObjectKey as ObjectKey from person per join inserted i on per.UID_Person = i.UID_Person union all select per.XObjectKey as ObjectKey7 from person per join deleted d on per.UID_Person = d.UID_Person ) p exec QER_PITShopHelperFill_Recalc @RecalcParameter_02, @GenprocID  end END TRY BEGIN8 CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end 9