Back to OIM Explorer

dbo.QBM_FCVDBD8E69187A9090BA7A05_

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 758 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_FCVDBD8E69187A9090BA7A05_(2  @in varBinary(max)3) RETURNS varbinary(204)5  WITH SCHEMABINDING6AS7BEGIN8  DECLARE @WorkIn varbinary(max)9  DECLARE @erg varbinary(20)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('SHA1',26          substring(@WorkIn, @i, 8000))27      END28      ELSE29      BEGIN30        SELECT31          @medium = @medium + HASHBYTES('SHA1',32          substring(@WorkIn, @i, 8000))33      END34      SELECT @i = @i + 800035    END36    SELECT @WorkIn = @medium37    SELECT @medium = NULL38  END39  SELECT40    @erg = HASHBYTES('SHA1',41    @WorkIn)42  RETURN(@erg)43END
Open raw exported source
SQL ยท Raw6 lines
1   create   function QBM_FCVDBD8E69187A9090BA7A05_(@in varBinary(max) ) returns varbinary(20) with SCHEMABINDING as begin declare @WorkIn varbinary2(max) declare @erg varbinary(20) 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('SHA1', substring(@WorkIn, @i, 8000)) end else begin select @medium = @medium + HASHBYTES('SHA1', substring(@WorkIn, @i, 80005)) end select @i = @i + 8000 end  select @WorkIn = @medium select @medium = null end select @erg = HASHBYTES('SHA1', @WorkIn)  return(@erg) end 6