Back to OIM Explorer

dbo.QBM_PGUIDReplaceLight

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 604 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_PGUIDReplaceLight_Multi source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL31 lines
1CREATE PROCEDURE QBM_PGUIDReplaceLight(2  @StartTable varchar(30),3  @StartColumn varchar(30),4  @ReplaceValues QBM_YParameterlist READONLY,5  @IncludeLob BIT = 16)7AS8BEGIN9  DECLARE @StartElements QBM_YParameterList10  SET XACT_ABORT OFF11  BEGIN TRY12    INSERT INTO @StartElements(Parameter1,13    Parameter2)14    SELECT15      @StartTable,16      @StartColumn17    EXEC QBM_PGUIDReplaceLight_Multi @StartElements,18      @ReplaceValues,19      @IncludeLob20  END TRY21  BEGIN CATCH22    EXEC QBM_PSessionErrorAdd DEFAULT23    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()24    RAISERROR(@Rethrow,25    18,26    1)27      WITH NOWAIT28  END CATCH29  ende:30  RETURN31END
Open raw exported source
SQL ยท Raw5 lines
1    create   procedure QBM_PGUIDReplaceLight (@StartTable varchar(30) , @StartColumn varchar(30) , @ReplaceValues QBM_YParameterlist readonly   2, @IncludeLob bit = 1 ) as begin declare @StartElements QBM_YParameterList SET XACT_ABORT OFF BEGIN TRY insert into @StartElements(Parameter1, Parameter23) select @StartTable, @StartColumn exec QBM_PGUIDReplaceLight_Multi @StartElements, @ReplaceValues, @IncludeLob END TRY BEGIN CATCH exec QBM_PSessionErrorAdd4 default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 5