Convert(int,sys.fn_sqlvarbasetostr(hashbytes('md5','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'. 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