Back to OIM Explorer

dbo.QBM_ZGUIDReplaceReady

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 504 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

Referenced By

  • No direct source references extracted.

Complete Source

SQL30 lines
1CREATE PROCEDURE QBM_ZGUIDReplaceReady(2  @SlotNumberDummy int,3  @Dummy1 varchar(38),4  @Dummy2 varchar(38),5  @GenProcIDDummy varchar(38)6)7AS8BEGIN9  DECLARE @UID_Database varchar(38)10  BEGIN TRY11    SELECT TOP 1 @UID_Database = d.UID_Database12    FROM DialogDatabase d13      WITH(readpast)14    WHERE15      d.IsMainDatabase = 116    DELETE QBMGuidReplace17      WITH(tablock)18    WHERE19      UID_Database = @UID_Database20  END TRY21  BEGIN CATCH22    EXEC QBM_PSessionErrorAdd DEFAULT23    RAISERROR('',24    18,25    1)26      WITH NOWAIT27  END CATCH28  endLabel:29  RETURN30END
Open raw exported source
SQL ยท Raw5 lines
1   create   procedure QBM_ZGUIDReplaceReady (@SlotNumberDummy int , @Dummy1 varchar(38) , @Dummy2 varchar(38) , @GenProcIDDummy varchar(38) ) as2 begin declare @UID_Database varchar(38)  BEGIN TRY select top 1 @UID_Database = d.UID_Database from DialogDatabase d with (readpast) where d.IsMainDatabase3 = 1 delete QBMGuidReplace with (tablock) where UID_Database = @UID_Database END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 14) WITH NOWAIT END CATCH endLabel: return end 5