It took me awhile to find how to create MD5 and SHA-1 hashes in SQL Server:

SELECT HASHBYTES(‘MD5’, ‘HASH THIS TEXT’)
SELECT HASHBYTES(‘SHA1’, ‘HASH THIS TEXT’)