Search for
in snippet title/description
in snippet text
Browse Code
Add-Ins
Blog
Language Feeds
Service Stats
FAQs
Feedback
About
Manage Your Code
Login
Register
Snippet: Convert plainpass to MD5 with SQL (SQL)
Title:
Convert plainpass to MD5 with SQL
Language:
SQL
Description:
Convert the MD5 Hash from your plain-Password with SQL
Views:
81
Author:
Mario Priebe (www.biggle.de)
Date Added:
3/12/2010
Copy
Code
SELECT SUBSTRING(sys.fn_sqlvarbasetostr(HashBytes('MD5', 'MyPassword')), 3, 32)
SELECT SUBSTRING(sys.fn_sqlvarbasetostr(HashBytes('MD5', 'MyPassword')), 3, 32)