Back to OIM Explorer

dbo.QBM_FTSessionErrorLoad

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

Source size: 1.366 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FCVIntToString source text reference
  • references source dbo.QBM_FCVStringPadLeft source text reference
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_FTSessionError_Split source text reference

References

Referenced By

Complete Source

SQL62 lines
1CREATE FUNCTION dbo.QBM_FTSessionErrorLoad(2) RETURNS @SessionError TABLE(ErrorMessage varchar(2047) collate database_default,3ErrorSeverity int DEFAULT 0,4ErrorState int DEFAULT 0,5ErrorNumber int DEFAULT 0,6ProcedureName varchar(30) collate database_default,7ProcedureLine int DEFAULT 0,8MessageDate datetime,9GenProcID varchar(38) collate database_default,10RepeatCounter int DEFAULT 0,11IsReThrow BIT DEFAULT 0,12SourceCode varchar(max) collate database_default,13RecordNumber int DEFAULT 014)15AS16BEGIN17  DECLARE @MessageKey varchar(30)18  DECLARE @LastMessage varchar(8000) = '#'19  DECLARE @Number int = 120  WHILE @number < 1000 AND @LastMessage > ' '21  BEGIN22    SELECT23      @MessageKey = CONCAT('ErrorMessage',24      dbo.QBM_FCVStringPadLeft(dbo.QBM_FCVIntToString(@number), 3, '0'))25    SELECT @LastMessage =26    LEFT(dbo.QBM_FGISessionContext(@MessageKey),27    8000)28    IF ISNULL(@LastMessage,29    '') = ''30    BEGIN31      CONTINUE32    END33    INSERT INTO @SessionError(ErrorMessage,34    ErrorSeverity,35    ErrorState,36    ErrorNumber,37    ProcedureName,38    ProcedureLine,39    MessageDate,40    GenProcID,41    RepeatCounter,42    IsReThrow,43    SourceCode,44    RecordNumber)45    SELECT46      ErrorMessage,47      ErrorSeverity,48      ErrorState,49      ErrorNumber,50      ProcedureName,51      ProcedureLine,52      MessageDate,53      GenProcID,54      RepeatCounter,55      IsReThrow,56      SourceCode,57      @Number58    FROM dbo.QBM_FTSessionError_Split(@LastMessage)59    SELECT @Number += 160  END61  RETURN62END
Open raw exported source
SQL ยท Raw10 lines
1 create   function dbo.QBM_FTSessionErrorLoad() returns  @SessionError table ( ErrorMessage varchar(2047) collate database_default  , ErrorSeverity2 int default 0 , ErrorState int default 0  , ErrorNumber int default 0 , ProcedureName varchar(30) collate database_default , ProcedureLine int default3 0 , MessageDate datetime , GenProcID varchar(38) collate database_default , RepeatCounter int default 0  , IsReThrow bit default 0 , SourceCode varchar4(max) collate database_default   , RecordNumber int default 0 ) as begin declare @MessageKey varchar(30) declare @LastMessage varchar(8000) = '#' declare5 @Number int = 1 while @number < 1000 and @LastMessage > ' ' begin select @MessageKey = CONCAT('ErrorMessage', dbo.QBM_FCVStringPadLeft( dbo.QBM_FCVIntToString6(@number), 3, '0') )  select @LastMessage = left(dbo.QBM_FGISessionContext(@MessageKey) , 8000)   if ISNULL(@LastMessage, '') = '' begin continue end insert7 into @SessionError(ErrorMessage, ErrorSeverity, ErrorState, ErrorNumber , ProcedureName, ProcedureLine, MessageDate , GenProcID, RepeatCounter, IsReThrow8, SourceCode, RecordNumber) select ErrorMessage, ErrorSeverity, ErrorState, ErrorNumber , ProcedureName, ProcedureLine, MessageDate , GenProcID, RepeatCounter9, IsReThrow, SourceCode, @Number from dbo.QBM_FTSessionError_Split(@LastMessage)  select @Number += 1 end  return end 10