Back to OIM Explorer

dbo.TSB_PTargetSystemObjectCount

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 901 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_PTElementsReferenced_I source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL47 lines
1CREATE PROCEDURE TSB_PTargetSystemObjectCount(2  @XObjectKeyStart varchar(138)3)4AS5BEGIN6  DECLARE @StartElements QBM_YParameterList7  SET nocount8    ON9  SET XACT_ABORT OFF10  BEGIN TRY11    drop TABLE12    IF EXISTS #QBMCollectorReferenceElements13    CREATE TABLE #QBMCollectorReferenceElements(14      TableName varchar(30) collate database_default,15      Objectkey varchar(138) collate database_default,16      XMarkedForDeletion int,17      SortOrder int DEFAULT 0,18      IsInsertRestrict BIT DEFAULT 0,19      IsDeleteRestrict BIT DEFAULT 0 primary key(ObjectKey)20    )21    INSERT INTO @StartElements(Parameter122  )23  SELECT @XObjectKeyStart24  EXEC QBM_PTElementsReferenced_I @StartElements,25    @SameModule = 1,26    @TopDown = 1,27    @ExcludeDS = 028END TRY29BEGIN CATCH30  EXEC QBM_PSessionErrorAdd DEFAULT31  RAISERROR('',32  18,33  134)35  WITH NOWAIT36END CATCH37ende:38SELECT39  TableName,40  COUNT(*41  )42  AS43  CountRecords44FROM #QBMCollectorReferenceElements45GROUP BY TableName46RETURN47END
Open raw exported source
SQL ยท Raw7 lines
1   create   procedure TSB_PTargetSystemObjectCount ( @XObjectKeyStart varchar(138) ) as begin declare @StartElements QBM_YParameterList set nocount2 on SET XACT_ABORT OFF BEGIN TRY drop table if exists #QBMCollectorReferenceElements create table #QBMCollectorReferenceElements (TableName varchar(30)3 collate database_default , Objectkey varchar(138) collate database_default , XMarkedForDeletion int , SortOrder int default 0 , IsInsertRestrict bit default4 0 , IsDeleteRestrict bit default 0 primary key (ObjectKey) ) insert into @StartElements(Parameter1) select @XObjectKeyStart exec QBM_PTElementsReferenced_I5 @StartElements, @SameModule = 1, @TopDown = 1, @ExcludeDS = 0 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT 6END CATCH ende:   select TableName, COUNT(*) as CountRecords from #QBMCollectorReferenceElements Group by TableName return end 7