Calculate MD5 Hash of File (or SHA-1, and other hash algorithms)

Demonstrates how to calculate a hash for a file's contents.

Download Chilkat Crypt ActiveX

CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @crypt int
    EXEC @hr = sp_OACreate 'Chilkat.Crypt2', @crypt OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @success int

    EXEC sp_OAMethod @crypt, 'UnlockComponent', @success OUT, 'Anything for 30-day trial'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @crypt, 'LastErrorText', @sTmp0 OUT

        PRINT @sTmp0
        RETURN
      END

    --  Set the name of the hash algorithm.
    --  Other choices include "sha1", "sha384", "sha512", "md2", "md5", and "haval".
    EXEC sp_OASetProperty @crypt, 'HashAlgorithm', 'md5'

    --  EncodingMode specifies the encoding of the hash output.
    --  It may be "hex", "url", "base64", or "quoted-printable".
    EXEC sp_OASetProperty @crypt, 'EncodingMode', 'hex'

    --  Files of any type may be hashed -- it doesn't matter
    --  if the file is binary or text...
    DECLARE @hashStr nvarchar(4000)

    EXEC sp_OAMethod @crypt, 'HashFileENC', @hashStr OUT, '/temp/something.dat'
    IF @hashStr Is NULL 
      BEGIN
        EXEC sp_OAGetProperty @crypt, 'LastErrorText', @sTmp0 OUT

        PRINT @sTmp0
        RETURN
      END


    PRINT @hashStr
END
GO