Sharing some of the useful snippets of code i stumble across with the world. It will mostly be Android, cloud computing, ColdFusion, SQL, Amazon AWS and other web technologies.
If you like what you read or it helps, drop in a comment and say so, it will be appreciated.
24 October 2008
hash function in sql
Just stumbled across this cool sql 2005 feature:
SELECT HashBytes('MD5','password')
Why did no one tell me about this before? This could have saved me HOURS of short pointless cf script writing.
1 comment:
this translates it into a string:
SELECT UPPER (SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('MD5', 'password')), 3, 32))
Post a Comment