Back to OIM Explorer

dbo.QBM_FGISessionErrorRaw

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 596 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

Referenced By

  • No direct source references extracted.

Complete Source

SQL29 lines
1CREATE FUNCTION dbo.QBM_FGISessionErrorRaw(2) RETURNS nvarchar(max3)4AS5BEGIN6  DECLARE @erg nvarchar(max) = ''7  DECLARE @MessageKey varchar(30)8  DECLARE @LastMessage varchar(1000) = '#'9  DECLARE @Number int = 110  WHILE @number < 1000 AND @LastMessage > ' '11  BEGIN12    SELECT13      @MessageKey = CONCAT('ErrorMessage',14      dbo.QBM_FCVStringPadLeft(dbo.QBM_FCVIntToString(@number), 3, '0'))15    SELECT @LastMessage = dbo.QBM_FGISessionContext(@MessageKey)16    IF ISNULL(@LastMessage,17    '') = ''18    BEGIN19      CONTINUE20    END21    SELECT22      @erg = CONCAT(@erg,23      @lastMessage,24      NCHAR(13),25      nchar(10))26    SELECT @Number += 127  END28  RETURN(@erg)29END
Open raw exported source
SQL ยท Raw5 lines
1create   function dbo.QBM_FGISessionErrorRaw() returns nvarchar(max) as begin declare @erg nvarchar(max) = '' declare @MessageKey varchar(30) declare2 @LastMessage varchar(1000) = '#' declare @Number int = 1 while @number < 1000 and @LastMessage > ' ' begin select @MessageKey = CONCAT('ErrorMessage',3 dbo.QBM_FCVStringPadLeft( dbo.QBM_FCVIntToString(@number), 3, '0') ) select @LastMessage = dbo.QBM_FGISessionContext(@MessageKey) if ISNULL(@LastMessage4, '') = '' begin continue end select @erg = CONCAT(@erg, @lastMessage, NCHAR(13), nchar(10))  select @Number += 1 end return(@erg) end 5