Back to OIM Explorer

dbo.QBM_PGUIDReplaceInsertPair

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

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

  • No direct source references extracted.

Complete Source

SQL42 lines
1CREATE PROCEDURE QBM_PGUIDReplaceInsertPair(2  @GuidOld varchar(38),3  @GuidNew varchar(38)4)5AS6BEGIN7  SET XACT_ABORT OFF8  BEGIN TRY9    IF @GuidOld > ' ' AND @GuidNew > ' '10    BEGIN11      INSERT INTO QBMGuidReplace(UID_Database,12      GuidOld,13      GuidNew)14      SELECT15        x.uid_database,16        @GuidOld,17        @GuidNew18      FROM(19      SELECT uid_database20      FROM DialogDatabase21      WHERE22        IsMainDatabase = 1) AS x23    END24    ELSE25    BEGIN26      RAISERROR('#LDS#Guids to replace must not be null.|',27      18,28      1)29        WITH NOWAIT30    END31  END TRY32  BEGIN CATCH33    EXEC QBM_PSessionErrorAdd DEFAULT34    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()35    RAISERROR(@Rethrow,36    18,37    1)38      WITH NOWAIT39  END CATCH40  ende:41  RETURN42END
Open raw exported source
SQL ยท Raw6 lines
1  create   procedure QBM_PGUIDReplaceInsertPair (@GuidOld varchar(38) , @GuidNew varchar(38)  ) as begin SET XACT_ABORT OFF BEGIN TRY if @GuidOld2 > ' ' and @GuidNew > ' ' begin insert into QBMGuidReplace(UID_Database, GuidOld, GuidNew) select x.uid_database, @GuidOld, @GuidNew from (select uid_database3 from DialogDatabase where IsMainDatabase = 1    ) as x end else begin RAISERROR ('#LDS#Guids to replace must not be null.|', 18, 1) WITH NOWAIT end END4 TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT5 END CATCH ende: return end 6