Back to OIM Explorer

dbo.QBM_FCVSessionErrorToMVP

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 992 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_FGISessionContext source text reference
  • references source dbo.QBM_FGIUTCDate source text reference

References

Referenced By

Complete Source

SQL21 lines
1CREATE FUNCTION dbo.QBM_FCVSessionErrorToMVP(2  @SessionError QBM_YSessionError READONLY3) RETURNS varchar(80004)5AS6BEGIN7  RETURN(8  SELECT9  LEFT(CONCAT(CONVERT(varchar(8000), ''), replace(e.ErrorMessage, char(7), ' '), CHAR(7), trim(str(e.ErrorSeverity)),10  CHAR(7), trim(str(e.ErrorState)), CHAR(7), trim(str(isnull(e.ErrorNumber, 50000))), CHAR(7), isnull(e.ProcedureName,11  '<no procedure>'), char(7), trim(str(e.ProcedureLine)), CHAR(7), convert(varchar(23), isnull(e.MessageDate,12  dbo.QBM_FGIUTCDate()), 121), CHAR(7), isnull(e.GenProcID, dbo.QBM_FGISessionContext((''))), CHAR(7), trim(str(e.RepeatCounter)),13  CHAR(7), trim(str(e.IsReThrow)), CHAR(7), convert(varchar(8000), replace(replace(replace(replace(14  LEFT(isnull(e.SourceCode, '<no code>'), 8000), '%', '[Percentsign]'), CHAR(13) + char(10), ' '), char(9),15  ' '), char(7), ' '))), 8000)16  FROM @SessionError e17  WHERE18    e.ElementIndex =(19  SELECT MAX(e2.ElementIndex)20  FROM @SessionError e2))21END
Open raw exported source
SQL ยท Raw8 lines
1  create   function dbo.QBM_FCVSessionErrorToMVP (@SessionError QBM_YSessionError readonly  ) returns varchar(8000) as begin return (   select left2(CONCAT( CONVERT(varchar(8000), '') , replace(e.ErrorMessage, char(7), ' ') , CHAR(7) , trim(str(e.ErrorSeverity)) , CHAR(7) , trim(str(e.ErrorState)) 3, CHAR(7) , trim(str(isnull(e.ErrorNumber, 50000))), CHAR(7) , isnull(e.ProcedureName, '<no procedure>'), char(7) , trim(str(e.ProcedureLine)), CHAR(7)4 , convert(varchar(23), isnull(e.MessageDate, dbo.QBM_FGIUTCDate()), 121 ), CHAR(7) , isnull(e.GenProcID, dbo.QBM_FGISessionContext(('') )), CHAR(7) , 5trim(str(e.RepeatCounter)), CHAR(7) , trim(str(e.IsReThrow)), CHAR(7) , convert(varchar(8000), replace(replace(replace(replace(left(isnull(e.SourceCode6, '<no code>') , 8000) , '%', '[Percentsign]') , CHAR(13) + char(10), ' ') , char(9), ' ' ) , char(7), ' ') )  ) , 8000 ) from @SessionError e where e.ElementIndex7 = ( select MAX(e2.ElementIndex) from @SessionError e2 ) )  end 8