Back to OIM Explorer

dbo.QBM_FCVBinaryToHash

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 291 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_FCVDBD8E69187A9090BA7A05_ source text reference

References

Referenced By

Complete Source

SQL14 lines
1CREATE FUNCTION dbo.QBM_FCVBinaryToHash(2  @in varBinary(max)3) RETURNS varbinary(204)5AS6BEGIN7  RETURN(CASE8  WHEN @in IS NULL OR DATALENGTH(@in) = 0 THEN9  HASHBYTES('SHA1', 0x0)10  WHEN DATALENGTH(@in) <= 8000 THEN11  HASHBYTES('SHA1', @in)12  ELSE dbo.QBM_FCVDBD8E69187A9090BA7A05_(@in)13  END)14END
Open raw exported source
SQL · Raw3 lines
1create   function dbo.QBM_FCVBinaryToHash(@in varBinary(max) ) returns varbinary(20)  as begin return( case when @in is null or DATALENGTH(@in) 2= 0 then HASHBYTES('SHA1', 0x0) when DATALENGTH(@in) <= 8000 then HASHBYTES('SHA1', @in) else dbo.QBM_FCVDBD8E69187A9090BA7A05_(@in) end ) end 3