Skip to content

Instantly share code, notes, and snippets.

@aaronhoffman

aaronhoffman/convert-hashbytes-varbinary-hex-char.sql

Last active December 13, 2017 17:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aaronhoffman/bcfcfb28c6712e5f769f945688f591de to your computer and use it in GitHub Desktop.
Save aaronhoffman/bcfcfb28c6712e5f769f945688f591de to your computer and use it in GitHub Desktop.
Download ZIP
Convert SQL hashbytes varbinary to hex char
Raw
convert-hashbytes-varbinary-hex-char.sql
convert(char(48), HASHBYTES('sha1', @HashInput), 2)
convert(char(64), HASHBYTES('sha2_256', @HashInput), 2)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment