Back to OIM Explorer

dbo.QBM_FCV8178BA33F2401031CF15D_

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 779 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

Complete Source

SQL43 lines
1CREATE FUNCTION QBM_FCV8178BA33F2401031CF15D_(2  @in varBinary(max)3) RETURNS varbinary(644)5  WITH SCHEMABINDING6AS7BEGIN8  DECLARE @WorkIn varbinary(max)9  DECLARE @erg varbinary(64)10  DECLARE @len int11  DECLARE @i int12  DECLARE @medium varbinary(max)13  SELECT @len = datalength(@in)14  SELECT @medium = NULL15  SELECT @WorkIn = @in16  WHILE DataLength(@WorkIn) > 800017  BEGIN18    SELECT @len = datalength(@WorkIn)19    SELECT @i = 120    WHILE @i <= @len21    BEGIN22      IF @medium IS NULL23      BEGIN24        SELECT25          @medium = HASHBYTES('SHA2_512',26          substring(@WorkIn, @i, 8000))27      END28      ELSE29      BEGIN30        SELECT31          @medium = @medium + HASHBYTES('SHA2_512',32          substring(@WorkIn, @i, 8000))33      END34      SELECT @i = @i + 800035    END36    SELECT @WorkIn = @medium37    SELECT @medium = NULL38  END39  SELECT40    @erg = HASHBYTES('SHA2_512',41    @WorkIn) ende:42  RETURN(@erg)43END
Open raw exported source
SQL ยท Raw7 lines
1     create   function QBM_FCV8178BA33F2401031CF15D_(@in varBinary(max) ) returns varbinary(64) with SCHEMABINDING as begin declare @WorkIn varbinary2(max) declare @erg varbinary(64) declare @len int declare @i int declare @medium varbinary(max) select @len = datalength(@in) select @medium = null select3 @WorkIn = @in while DataLength(@WorkIn) > 8000 begin select @len = datalength(@WorkIn)  select @i = 1 while @i <= @len begin if @medium is null begin 4select @medium = HASHBYTES('SHA2_512', substring(@WorkIn, @i, 8000)) end else begin select @medium = @medium + HASHBYTES('SHA2_512', substring(@WorkIn,5 @i, 8000)) end select @i = @i + 8000 end  select @WorkIn = @medium select @medium = null end select @erg = HASHBYTES('SHA2_512', @WorkIn) ende: return6(@erg) end 7