Back to OIM Explorer

dbo.QBM_FCVBinaryToHash512

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 304 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_FCV8178BA33F2401031CF15D_ source text reference
  • references source dbo.QBM_FCVBinaryToHash source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL14 lines
1CREATE FUNCTION dbo.QBM_FCVBinaryToHash512(2  @in varBinary(max)3) RETURNS varbinary(644)5AS6BEGIN7  RETURN(CASE8  WHEN @in IS NULL OR DATALENGTH(@in) = 0 THEN9  HASHBYTES('SHA2_512', 0x0)10  WHEN DATALENGTH(@in) <= 8000 THEN11  HASHBYTES('SHA2_512', @in)12  ELSE dbo.QBM_FCV8178BA33F2401031CF15D_(@in)13  END)14END
Open raw exported source
SQL ยท Raw4 lines
1create   function dbo.QBM_FCVBinaryToHash512(@in varBinary(max) ) returns varbinary(64)  as begin return( case when @in is null or DATALENGTH(@in2) = 0 then HASHBYTES('SHA2_512', 0x0) when DATALENGTH(@in) <= 8000 then HASHBYTES('SHA2_512', @in) else dbo.QBM_FCV8178BA33F2401031CF15D_(@in) end ) end3 4