Back to OIM Explorer

dbo.QBM_FGI093F4EF597272C7DCA06D_1

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 1.592 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_FCVBigIntToString source text reference
  • references source dbo.QBM_FCVBinaryToString source text reference
  • references source dbo.QBM_FCVBitToString source text reference
  • references source dbo.QBM_FCVDatetimeToString source text reference
  • references source dbo.QBM_FCVFloatToString source text reference
  • references source dbo.QBM_FCVIntToString source text reference

References

Referenced By

Complete Source

SQL104 lines
1CREATE FUNCTION dbo.QBM_FGI093F4EF597272C7DCA06D_1(2  @Ordernumber int,3  @OrderNumberReverse int,4  @ColumnName varchar(30),5  @Alias varchar(30),6  @SchemaDataType varchar(30),7  @ParentTable varchar(30),8  @CountDisplayItems int9) RETURNS nvarchar(max10)11  WITH SCHEMABINDING12AS13BEGIN14  DECLARE @Kernel nvarchar(max) = N ''15  DECLARE @Erg nvarchar(max) = N ''16  SELECT @Kernel = CASE @SchemaDatatype17  WHEN 'int' THEN18  CONCAT('dbo.QBM_FCVIntToString(',19  @Alias,20  '.',21  @columnname,22  ')')23  WHEN 'bigint' THEN24  CONCAT('dbo.QBM_FCVBigIntToString(',25  @Alias,26  '.',27  @columnname,28  ')')29  WHEN 'datetime' THEN30  CONCAT('dbo.QBM_FCVDateTimeToString(',31  @Alias,32  '.',33  @columnname,34  ')')35  WHEN 'Float' THEN36  CONCAT('dbo.QBM_FCVFloatToString(',37  @Alias,38  '.',39  @columnname,40  ')')41  WHEN 'Bit' THEN42  CONCAT('dbo.QBM_FCVBitToString(',43  @Alias,44  '.',45  @columnname,46  ')')47  WHEN 'varbinary' THEN48  CONCAT('dbo.QBM_FCVBinaryToString(',49  @Alias,50  '.',51  @columnname,52  ', 0)')53  ELSE CONCAT('isnull( ',54  @Alias,55  '.',56  @columnname,57  ', '''')')58  END59  SELECT60    @kernel = CONCAT('left (',61    char(13),62    char(10),63    char(9),64    char(9),65    @Kernel,66    char(13),67    char(10),68    char(9),69    char(9),70    ',',71    trim(str(256 / @CountDisplayItems)),72    ')')73  IF @OrderNumberReverse > 174  BEGIN75    SELECT76      @Erg = CONCAT(' case ',77      char(13),78      char(10),79      '		when ',80      @alias,81      '.',82      @ColumnName,83      ' is null then ',84      char(13),85      char(10),86      '#',87      trim(str(@Ordernumber)),88      trim(str(@OrderNumberReverse-1)),89      '#',90      char(13),91      char(10),92      '		else ',93      @Kernel,94      char(13),95      char(10),96      ' end ')97  END98  ELSE99  BEGIN100    SELECT @erg = @Kernel101  END102  endLabel:103  RETURN(@erg)104END
Open raw exported source
SQL ยท Raw12 lines
1           create   function dbo.QBM_FGI093F4EF597272C7DCA06D_1(@Ordernumber int  , @OrderNumberReverse int  , @ColumnName varchar(30) , @Alias 2varchar(30) , @SchemaDataType varchar(30) , @ParentTable varchar(30) , @CountDisplayItems int   ) returns nvarchar(max) with SCHEMABINDING as begin declare3 @Kernel nvarchar(max) = N'' declare @Erg nvarchar(max) = N'' select @Kernel = case @SchemaDatatype when 'int' then concat('dbo.QBM_FCVIntToString(' , 4@Alias , '.' , @columnname , ')' ) when 'bigint' then concat('dbo.QBM_FCVBigIntToString(' , @Alias , '.' , @columnname , ')') when 'datetime' then concat5('dbo.QBM_FCVDateTimeToString(' , @Alias , '.' , @columnname , ')') when 'Float' then concat('dbo.QBM_FCVFloatToString(' , @Alias , '.' , @columnname ,6 ')' ) when 'Bit' then concat('dbo.QBM_FCVBitToString(' , @Alias , '.' , @columnname , ')' ) when 'varbinary' then concat('dbo.QBM_FCVBinaryToString(' 7, @Alias , '.' , @columnname , ', 0)' ) else concat ( 'isnull( ', @Alias , '.' , @columnname , ', '''')' ) end select @kernel = concat('left (' , char(138), char(10) , char(9), char(9), @Kernel , char(13), char(10) , char(9), char(9), ',', trim(str(256 / @CountDisplayItems)) , ')' ) if @OrderNumberReverse9 > 1  begin select @Erg = concat( ' case ', char(13) , char(10) ,'		when ' , @alias, '.', @ColumnName, ' is null then ' , char(13) , char(10) , '#', trim10(str(@Ordernumber)) , trim(str(@OrderNumberReverse-1)), '#' , char(13) , char(10) , '		else ' , @Kernel , char(13) , char(10) , ' end ' ) end else begin11 select @erg = @Kernel end endLabel: return (@erg) end 12