Back to OIM Explorer

dbo.QER_ZITShopCheckMethodBO

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 515 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.QER_PITShopCheckMethodBO source text reference
  • references source dbo.QER_ZITShopCheck source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL33 lines
1CREATE PROCEDURE QER_ZITShopCheckMethodBO(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @XUser nvarchar(64) = object_name(@@procid)7  DECLARE @Boards QBM_YCursorBuffer8  BEGIN TRY9    INSERT INTO @Boards(UID1,10    UID2)11    SELECT12      UID_Parameter,13      GenProcID14    FROM QBMDBQueueCurrent cu15      WITH(readpast)16    WHERE17      cu.SlotNumber = @SlotNumber18    IF @@rowcount = 019    BEGIN20      GOTO EndLabel21    END22    EXEC QER_PITShopCheckMethodBO @Boards23  END TRY24  BEGIN CATCH25    EXEC QBM_PSessionErrorAdd DEFAULT26    RAISERROR('',27    18,28    1)29      WITH NOWAIT30  END CATCH31  endLabel:32  RETURN33END
Open raw exported source
SQL ยท Raw5 lines
1create   procedure QER_ZITShopCheckMethodBO (@SlotNumber int) as begin declare @XUser nvarchar(64) = object_name(@@procid) declare @Boards QBM_YCursorBuffer2 BEGIN TRY insert into @Boards(UID1, UID2) select UID_Parameter, GenProcID from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber = @SlotNumber 3if @@rowcount = 0 begin goto EndLabel end exec QER_PITShopCheckMethodBO @Boards END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 184, 1) WITH NOWAIT END CATCH  endLabel: return end 5