Back to OIM Explorer

dbo.QBM_ZTableReplace

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 400 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_PTableReload source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL26 lines
1CREATE PROCEDURE QBM_ZTableReplace(2  @SlotNumberDummy int,3  @TableName varchar(38),4  @Dummy varchar(38),5  @Genprocid varchar(38)6)7AS8BEGIN9  BEGIN TRY10    IF @TableName <> 'QBMGuidReplace'11    BEGIN12      EXEC QBM_PTableReload @TableName,13        @WithReplace = 1,14        @Genprocid = @Genprocid15    END16  END TRY17  BEGIN CATCH18    EXEC QBM_PSessionErrorAdd DEFAULT19    RAISERROR('',20    18,21    1)22      WITH NOWAIT23  END CATCH24  endLabel:25  RETURN26END
Open raw exported source
SQL ยท Raw4 lines
1   create   procedure QBM_ZTableReplace (@SlotNumberDummy int , @TableName varchar(38) , @Dummy varchar(38) , @Genprocid varchar(38) ) as begin 2BEGIN TRY if @TableName <> 'QBMGuidReplace' begin exec QBM_PTableReload @TableName , @WithReplace = 1, @Genprocid = @Genprocid end END TRY BEGIN CATCH 3exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end 4