Back to OIM Explorer

dbo.QBM_FCVFloatToString_Byte

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 591 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_FCVStringToList source text reference
  • references source dbo.QBM_FCVFloatToString source text reference
  • references source dbo.QBM_FCVStringToListItem source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL33 lines
1CREATE FUNCTION dbo.QBM_FCVFloatToString_Byte(2  @Bytes Float3) RETURNS varchar(644)5AS6BEGIN7  DECLARE @erg varchar(64)8  DECLARE @div int = 19  DECLARE @MehrByte float = @Bytes10  DECLARE @Einheit varchar(200) = CONCAT('Byte',11  char(7),12  'KB',13  char(7),14  'MB',15  char(7),16  'GB',17  char(7),18  'TB',19  char(7),20  'PB',21  char(7),22  'EB')23  WHILE @MehrByte > 1000.0 AND @div < 724  BEGIN25    SELECT @MehrByte /= 1024.026    SELECT @div += 127  END28  SELECT29    @erg = CONCAT(convert(varchar(64), round(@MehrByte, 2)),30    ' ',31    dbo.QBM_FCVStringToListItem(@Einheit, char(7), 1, @div, 0)) endLabel:32  RETURN(@erg)33END
Open raw exported source
SQL ยท Raw5 lines
1    create   function dbo.QBM_FCVFloatToString_Byte (@Bytes Float) returns varchar(64) as begin declare @erg varchar(64) declare @div int = 1 declare2 @MehrByte float = @Bytes declare @Einheit varchar(200) = concat('Byte'  , char(7) , 'KB'  , char(7) , 'MB'  , char(7) , 'GB'  , char(7) , 'TB'  , char3(7) , 'PB'  , char(7) , 'EB'  ) while @MehrByte > 1000.0 and @div < 7 begin select @MehrByte /= 1024.0 select @div += 1 end select @erg = concat(convert4(varchar(64), round(@MehrByte,2)) , ' ' , dbo.QBM_FCVStringToListItem(@Einheit, char(7), 1, @div, 0) ) endLabel: return (@erg) end 5