Convert(int,sys.fn_sqlvarbasetostr(hashbytes('md5','1455985476'))) Now

: This attempts to cast that hex string into a 4-byte integer. Because the hash is much larger than an integer, SQL Server typically truncates the value, often resulting in an arithmetic overflow or returning a signed integer based on the last 4 bytes of the hash. The Result

: This generates a 128-bit MD5 hash of the input string, returned as a varbinary value. : This attempts to cast that hex string

: Creating a non-obvious integer ID from a sensitive string. SQL Server typically truncates the value