Home Forums SQL Server 2014 Development - SQL Server 2014 Trying to use the HASHBYTES of a nvarcar(Max) RE: Trying to use the HASHBYTES of a nvarcar(Max)

  • July 31, 2016 at 1:22 am

    #1892798

    joejuska (7/30/2016)

    No I DO NOT WANT TO HASH ONLY THE FIRST 50 CHARACTERS. I WANT TO HASH THE ENTIRE FILE BUT HAVE THE RESULTANT FIELD NVARCHAR(50) OR CHAR(50) INSTEAD OF SSMS MAKING THE RESULTANT FIELD NVARCHAR(MAX)

    How large is the input (in characters)? Do you understand fully the hashbyte function? The code you posted

    left(hashbytes('MD5',[ASCII File]), 50) does not reflect that.

    😎