Methodic Madness

A Dev Blog with a Method

Wednesday, January 14, 2015

SQL: Convert a Hash to a Varchar

For some reason this task always stumps me, so here is the solution:
CONVERT([varchar](512), hashbytes('sha', col), 2)
Thanks to Basit
Posted by JP at 10:47 AM No comments:
Labels: sql
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Profile

JP
View my complete profile

Archives

  • ►  2016 (1)
    • ►  July (1)
  • ▼  2015 (1)
    • ▼  January (1)
      • SQL: Convert a Hash to a Varchar
  • ►  2012 (3)
    • ►  October (1)
    • ►  April (1)
    • ►  March (1)
  • ►  2011 (3)
    • ►  June (1)
    • ►  May (1)
    • ►  April (1)
  • ►  2010 (7)
    • ►  June (3)
    • ►  April (2)
    • ►  January (2)
  • ►  2009 (8)
    • ►  November (1)
    • ►  September (1)
    • ►  August (2)
    • ►  June (1)
    • ►  May (1)
    • ►  January (2)
  • ►  2008 (4)
    • ►  December (2)
    • ►  October (1)
    • ►  August (1)

More About Me

  • Ithi Enterprises
  • LinkedIn Profile
  • Stack Overflow CV

Tags

c# nhibernate iis7 mongodb nosql server2008 sqlserver2008 windows7 .net activedirectory activereports audio chrome database dns domaincontroller elmah email extensions ftp google grapecity hangouts hosting icriteria ie6 javascript jquery jquery validation loopbackadapter msdeploy mvc networking queryover reflection server2003 sql ssl virtualization webdesign

Subscribe

Posts
Atom
Posts
All Comments
Atom
All Comments

Other Reads

  • Yet Another C# Blog

combined Stack Exchange profile for Joel Potter
© Ithi Enterprises. Simple theme. Theme images by fpm. Powered by Blogger.