Back to OIM Explorer

dbo.QBM_PTableRevisionSetMulti

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 589 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_PTableRevisionSetMulti_i source text reference

References

Referenced By

Complete Source

SQL33 lines
1CREATE PROCEDURE QBM_PTableRevisionSetMulti(2  @TableNamesForRevision QBM_YParameterList READONLY3)4AS5BEGIN6  DECLARE @Debugswitch int = 07  DECLARE @SQLCmd nvarchar(max)8  DECLARE @TableNamesString varchar(max)9  SET XACT_ABORT OFF10  BEGIN TRY11    SET nocount12      ON13    IF NOT EXISTS(14      SELECT TOP 1 115      FROM @TableNamesForRevision)16    BEGIN17      GOTO endlabel18    END19    SELECT20      @TableNamesString = STRING_AGG(t.Parameter1,21      ',')22    FROM @TableNamesForRevision t23    EXEC QBM_PTableRevisionSetMulti_i @TableNamesString24  END TRY25  BEGIN CATCH26  END CATCH27  endLabel:28  IF @DebugSwitch > 029  BEGIN30    print 'bin heil raus'31  END32  RETURN33END
Open raw exported source
SQL ยท Raw5 lines
1create   procedure QBM_PTableRevisionSetMulti (@TableNamesForRevision QBM_YParameterList readonly ) as begin declare @Debugswitch int = 0 declare2 @SQLCmd nvarchar(max) declare @TableNamesString varchar(max) SET XACT_ABORT OFF BEGIN TRY set nocount on if not exists (select top 1 1 from @TableNamesForRevision3 ) begin goto endlabel end select @TableNamesString = STRING_AGG( t.Parameter1 , ',') from @TableNamesForRevision t exec QBM_PTableRevisionSetMulti_i @TableNamesString4 END TRY BEGIN CATCH   END CATCH endLabel: if @DebugSwitch > 0 begin print 'bin heil raus' end return end 5