Back to OIM Explorer

dbo.QBM_FGIDB_Name

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL21 lines
1CREATE FUNCTION dbo.QBM_FGIDB_Name(2) RETURNS nvarchar(523)4AS5BEGIN6  DECLARE @erg nvarchar(52)7  DECLARE @dbname nvarchar(128) = db_name()8  IF len(@dbname) > 529  BEGIN10    SELECT11      @erg = CONCAT('DB_ID_',12      RIGHT('00000' + ltrim(str(db_id())), 5),13      '_',14      substring(dbo.QBM_FCVBinaryToString(dbo.QBM_FCVStringToHash(@dbname), 0), 3, 40))15  END16  ELSE17  BEGIN18    SELECT @erg = @dbname19  END20  RETURN(@erg)21END
Open raw exported source
SQL ยท Raw4 lines
1  create   function dbo.QBM_FGIDB_Name() returns nvarchar(52) as begin  declare @erg nvarchar(52) declare @dbname nvarchar(128) = db_name()  if 2len(@dbname) > 52 begin select @erg = concat( 'DB_ID_' , right('00000' + ltrim(str(db_id())),5) , '_' , substring(dbo.QBM_FCVBinaryToString(dbo.QBM_FCVStringToHash3(@dbname), 0), 3, 40) ) end else begin  select @erg = @dbname end return (@erg) end 4