: Generates a 128-bit MD5 hash of the string '1522521276'. The resulting binary value is 0xE4F3F000CC6A3F98F7A831A601E6E002 .
), it wraps around into a negative value in two's complement notation. : Generates a 128-bit MD5 hash of the string '1522521276'
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'
: 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 ( : Generates a 128-bit MD5 hash of the string '1522521276'