Back to OIM Explorer

dbo.QBM_PFESimulationFill

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 552 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL34 lines
1CREATE PROCEDURE QBM_PFESimulationFill(2  @Data QBM_YTriggerOperation READONLY3)4AS5BEGIN6  SET XACT_ABORT OFF7  BEGIN TRY8    IF object_id(N 'tempdb..#TriggerOperation') IS NOT NULL9    BEGIN10      INSERT INTO #TriggerOperation(Operation,11      BaseObjectType,12      ColumnName,13      ObjectKey,14      OldValue)15      SELECT16        Operation,17        BaseObjectType,18        ColumnName,19        ObjectKey,20        OldValue21      FROM @data22    END23  END TRY24  BEGIN CATCH25    EXEC QBM_PSessionErrorAdd DEFAULT26    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()27    RAISERROR(@Rethrow,28    18,29    1)30      WITH NOWAIT31  END CATCH32  endLabel:33  RETURN34END
Open raw exported source
SQL ยท Raw5 lines
1 create   procedure QBM_PFESimulationFill (@Data QBM_YTriggerOperation readonly ) as begin SET XACT_ABORT OFF BEGIN TRY if object_id(N'tempdb..#TriggerOperation'2) is not null begin insert into #TriggerOperation (Operation, BaseObjectType, ColumnName, ObjectKey, OldValue) select Operation, BaseObjectType, ColumnName3, ObjectKey, OldValue from @data end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow4() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel: return end 5