Skip to content
John Huang's Blog

John Huang's Blog

About SQL Server, Schema z, and Others

  • Schema Z
  • About…

fn_repl_hash_binary

Generate MD5 Value from Big Data

January 16, 2012 by John H

How do you generate MD5 hash in SQL Server? You might immediately tell that it can be generated MD5 by calling HASHBYTES built-in function. That’s true, however, it only accepts generating MD5 hashes from variables which has less than 8000 bytes. How would you generate MD5 hash from big variables?

Read more

Categories Encryption/Decryption, T-SQL Tags fn_repl_hash_binary 13 Comments
© 2025 John Huang's Blog • Built with GeneratePress