Back to OIM Explorer

dbo.QBM_PTElementsReferenced_L

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 872 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 source dbo.QBM_PTElementsReferenced_I source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL41 lines
1CREATE PROCEDURE QBM_PTElementsReferenced_L(2  @StartElements QBM_YParameterList READONLY,3  @SameModule BIT = 1,4  @TopDown BIT = 1,5  @ExcludeDS BIT = 06)7AS8BEGIN9  SET XACT_ABORT OFF10  BEGIN TRY11    SET nocount12      ON drop TABLE13    IF EXISTS #QBMCollectorReferenceElements14    CREATE TABLE #QBMCollectorReferenceElements(15      TableName varchar(30) collate database_default,16      Objectkey varchar(138) collate database_default,17      XMarkedForDeletion int,18      SortOrder int DEFAULT 0,19      IsInsertRestrict BIT DEFAULT 0,20      IsDeleteRestrict BIT DEFAULT 0 primary key(ObjectKey)21    )22    EXEC QBM_PTElementsReferenced_I @StartElements,23      @SameModule,24      @TopDown,25      @ExcludeDS26  END TRY27  BEGIN CATCH28    EXEC QBM_PSessionErrorAdd DEFAULT29    DECLARE @Rethrow varchar(100030  ) = dbo.QBM_FGISessionErrorRethrow(31)32RAISERROR(@Rethrow,3318,34135)36  WITH NOWAIT37END CATCH38endLabel:39SELECT *40FROM #QBMCollectorReferenceElements41END
Open raw exported source
SQL ยท Raw7 lines
1   create   procedure QBM_PTElementsReferenced_L (@StartElements QBM_YParameterList readonly , @SameModule bit = 1 , @TopDown bit = 1 , @ExcludeDS2 bit = 0 ) as begin SET XACT_ABORT OFF BEGIN TRY set nocount on drop table if exists #QBMCollectorReferenceElements create table #QBMCollectorReferenceElements3 (TableName varchar(30) collate database_default , Objectkey varchar(138) collate database_default , XMarkedForDeletion int , SortOrder int default 0 ,4 IsInsertRestrict bit default 0 , IsDeleteRestrict bit default 0 primary key (ObjectKey) ) exec QBM_PTElementsReferenced_I @StartElements, @SameModule,5 @TopDown, @ExcludeDS END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR6 (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel:   select * from #QBMCollectorReferenceElements end 7