Back to OIM Explorer

dbo.QBM_PIndexCreateGenerated_XO_M

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 944 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_FCVGUIDToModuleOwner source text reference
  • references source dbo.QBM_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PIndexCreate source text reference
  • references source dbo.QBM_PIndexCreateGenerated source text reference
  • references source dbo.QBM_PIndexCreateGenerated_XO source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL43 lines
1CREATE PROCEDURE QBM_PIndexCreateGenerated_XO_M(2  @TablePattern varchar(64),3  @ModuleNameOrPattern varchar(16) = '%'4)5AS6BEGIN7  DECLARE @TableName varchar(30)8  DECLARE @Names TABLE(TableName varchar(30) collate database_default)9  SET XACT_ABORT OFF10  BEGIN TRY11    INSERT INTO @Names(TableName)12    SELECT t.TableName13    FROM DialogTable t14    WHERE15      t.TableType IN('B',16    'T') AND t.TableName LIKE @TablePattern AND dbo.QBM_FCVGUIDToModuleOwner(t.UID_DialogTable) LIKE @ModuleNameOrPattern17    SELECT @TableName = '#'18    WHILE @TableName > ' '19    BEGIN20      SELECT @TableName = NULL21      SELECT TOP 1 @TableName = n.TableName22      FROM @Names n23      IF @TableName IS NULL24      BEGIN25        CONTINUE26      END27      DELETE @Names28      WHERE29        TableName = @TableName30      EXEC QBM_PIndexCreateGenerated_XO @TableName31    END32  END TRY33  BEGIN CATCH34    EXEC QBM_PSessionErrorAdd DEFAULT35    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()36    RAISERROR(@Rethrow,37    18,38    1)39      WITH NOWAIT40  END CATCH41  ende:42  RETURN43END
Open raw exported source
SQL ยท Raw7 lines
1 create   procedure QBM_PIndexCreateGenerated_XO_M (@TablePattern varchar(64) , @ModuleNameOrPattern varchar(16) = '%'  ) as begin declare @TableName2 varchar(30) declare @Names table (TableName varchar(30) collate database_default ) SET XACT_ABORT OFF BEGIN TRY insert into @Names(TableName) select t.TableName3 from DialogTable t where t.TableType in ('B', 'T') and t.TableName like @TablePattern and dbo.QBM_FCVGUIDToModuleOwner(t.UID_DialogTable) like @ModuleNameOrPattern4 select @TableName = '#' while @TableName > ' ' begin select @TableName = null select top 1 @TableName = n.TableName from @Names n if @TableName is null5 begin continue end delete  @Names where TableName = @TableName    exec QBM_PIndexCreateGenerated_XO @TableName   end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd6 default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 7