Back to OIM Explorer

dbo.QER_P98F5E10C6A9349A1EBFB2C2_

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 856 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_PSessionErrorAdd source text reference
  • references source dbo.QBM_PWaitForSeconds source text reference

References

Referenced By

Complete Source

SQL44 lines
1CREATE PROCEDURE QER_P98F5E10C6A9349A1EBFB2C2_(2  @UsageArea varchar(1)3)4AS5BEGIN6  DECLARE @weiter int7  DECLARE @ObjectKeyToDelete QBM_YParameterList8  SET XACT_ABORT OFF9  BEGIN TRY10    INSERT INTO @ObjectKeyToDelete(Parameter2)11    SELECT TOP 500 m.ObjectKey12    FROM QERBufferRecalcDecisionMaker m13      WITH(readpast)14    WHERE15      m.UsageArea = @UsageArea AND m.ProcessState = 216    SELECT @weiter = @@ROWCOUNT17    IF @weiter = 018    BEGIN19      GOTO endlabel20    END21    BEGIN TRY22      DELETE QERBufferRecalcDecisionMaker23      FROM QERBufferRecalcDecisionMaker m24        WITH(ForceSeek)25      JOIN @ObjectKeyToDelete d26        ON m.ObjectKey = d.Parameter227      WHERE28        m.UsageArea = @UsageArea AND m.ProcessState = 229    END TRY30    BEGIN CATCH31      EXEC QBM_PWaitForSeconds 0.532    END CATCH33  END TRY34  BEGIN CATCH35    EXEC QBM_PSessionErrorAdd DEFAULT36    RAISERROR('',37    18,38    1)39      WITH NOWAIT40  END CATCH41  endLabel:42  SET lock_timeout -143  RETURN(@weiter)44END
Open raw exported source
SQL ยท Raw7 lines
1     create   procedure QER_P98F5E10C6A9349A1EBFB2C2_(@UsageArea varchar(1) ) as begin declare @weiter int declare @ObjectKeyToDelete QBM_YParameterList2  SET XACT_ABORT OFF BEGIN TRY insert into @ObjectKeyToDelete(Parameter2) select top 500 m.ObjectKey from QERBufferRecalcDecisionMaker m with (readpast3) where m.UsageArea = @UsageArea and m.ProcessState = 2 select @weiter = @@ROWCOUNT if @weiter = 0 begin goto endlabel end BEGIN TRY delete QERBufferRecalcDecisionMaker4 from QERBufferRecalcDecisionMaker m with (ForceSeek) join @ObjectKeyToDelete d on m.ObjectKey = d.Parameter2 where m.UsageArea = @UsageArea and m.ProcessState5 = 2 END TRY BEGIN CATCH  exec QBM_PWaitForSeconds 0.5 END CATCH END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT6 END CATCH endLabel: set lock_timeout -1 return (@weiter) end 7