Back to OIM Explorer

dbo.QBM_FGICodeName

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 339 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_FCVBinaryToString source text reference
  • references source dbo.QBM_FCVStringToHash source text reference

Complete Source

SQL14 lines
1CREATE FUNCTION dbo.QBM_FGICodeName(2  @Prefix varchar(5),3  @SourceString nvarchar(256)4) RETURNS varchar(305)6AS7BEGIN8  DECLARE @erg varchar(30)9  SELECT @erg =10  LEFT('GEN' + '_' + @prefix + SUBSTRING(dbo.QBM_FCVBinaryToString(dbo.QBM_FCVStringToHash(upper(@prefix+@SourceString)),11  0), 3, 30),12  30) endLabel:13  RETURN(@erg)14END
Open raw exported source
SQL ยท Raw4 lines
1  create   function dbo.QBM_FGICodeName( @Prefix varchar(5)  , @SourceString nvarchar(256)  ) returns varchar(30)as begin  declare @erg varchar(302) select @erg = left( 'GEN' + '_' + @prefix + SUBSTRING( dbo.QBM_FCVBinaryToString( dbo.QBM_FCVStringToHash(upper(@prefix+@SourceString)), 0) , 3, 30 )3 , 30 ) endLabel: return (@erg) end 4