Back to OIM Explorer

dbo.QBM_PBufferT_ProcessAll_Delta

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.125 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_PBufferT_DeleteNonlinear source text reference
  • references source dbo.QBM_PBufferT_ProcAll_Delta_i source text reference
  • references source dbo.QBM_PBufferT_ProcessAll source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL49 lines
1CREATE PROCEDURE QBM_PBufferT_ProcessAll_Delta(2  @ModuleName varchar(3)3)4AS5BEGIN6  DECLARE @DebugLevel char(1) = 'W'7  SET XACT_ABORT OFF8  BEGIN TRY9    IF OBJECT_ID('tempdb..#QBMBufferTransferOneTable') IS NULL10    BEGIN11      CREATE TABLE #QBMBufferTransferOneTable(12        ColumnName varchar(30) collate database_default,13        ObjectKeyOfRow varchar(138) collate database_default,14        ContentShort nvarchar(400) collate database_default,15        HasContentFull BIT DEFAULT 0,16        ContentFull nvarchar(max) collate database_default17      )18    END19    IF EXISTS(20      SELECT TOP 1 121      FROM QBMBufferTransfer t22      WHERE23        t.TableName = 'QBMNonLinearDepend'24  )25  BEGIN26    truncate TABLE #QBMBufferTransferOneTable27    EXEC QBM_PBufferT_ProcAll_Delta_i @Modulename,28    'QBMNonLinearDepend'29    DELETE QBMBufferTransfer30    WHERE31      TableName = 'QBMNonLinearDepend'32  END33  EXEC QBM_PBufferT_DeleteNonlinear @ModuleName34  EXEC QBM_PBufferT_ProcAll_Delta_i @Modulename,35  '%'36END TRY37BEGIN CATCH38  EXEC QBM_PSessionErrorAdd DEFAULT39  DECLARE @Rethrow varchar(100040) = dbo.QBM_FGISessionErrorRethrow(41)42RAISERROR(@Rethrow,4318,44145)46  WITH NOWAIT47END CATCH48endLabel: truncate TABLE #QBMBufferTransferOneTable49END
Open raw exported source
SQL ยท Raw9 lines
1  create   procedure QBM_PBufferT_ProcessAll_Delta (@ModuleName varchar(3) ) as begin declare @DebugLevel char(1) = 'W'  SET XACT_ABORT OFF BEGIN2 TRY  if OBJECT_ID('tempdb..#QBMBufferTransferOneTable') is null begin  create table #QBMBufferTransferOneTable (ColumnName varchar(30) collate database_default3 , ObjectKeyOfRow varchar(138) collate database_default  , ContentShort nvarchar(400) collate database_default , HasContentFull bit default 0 , ContentFull4 nvarchar(max) collate database_default ) end if exists (select top 1 1 from QBMBufferTransfer t where t.TableName = 'QBMNonLinearDepend' ) begin  truncate5 table #QBMBufferTransferOneTable exec QBM_PBufferT_ProcAll_Delta_i @Modulename, 'QBMNonLinearDepend' delete QBMBufferTransfer where TableName = 'QBMNonLinearDepend'6 end exec QBM_PBufferT_DeleteNonlinear @ModuleName  exec QBM_PBufferT_ProcAll_Delta_i @Modulename, '%' END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default7 declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel: truncate table #QBMBufferTransferOneTable8 end 9