Convert(int,sys.fn_sqlvarbasetostr(hashbytes('md5','1522521276'))) Official

The T-SQL expression convert(int,sys.fn_sqlvarbasetostr(HashBytes('MD5','1522521276'))) returns the integer value . Breakdown of the Execution

: Generates a 128-bit MD5 hash of the string '1522521276'. The resulting binary value is 0xE4F3F000CC6A3F98F7A831A601E6E002 . The T-SQL expression convert(int,sys

: SQL Server takes the beginning of that hex string and attempts to fit it into a 4-byte integer. Because the first 4 bytes ( 0xE4F3F000 ) represent a value larger than the maximum positive signed integer ( The T-SQL expression convert(int

), it wraps around into a negative value in two's complement notation. The T-SQL expression convert(int,sys

: This internal function converts that binary hash into its string representation: '0xe4f3f000cc6a3f98f7a831a601e6e002' .