Cryptography stored procedures for SQL Server gives you a set of cryptography extended stored procedures to use in T-SQL queries. This library uses Microsoft Cryptographic API (CryptoAPI) to operate.

There are the following extended stored procedures:
· xp_HashCreate creates a new hash object (MD5 or SHA) and returns a handle on it
· xp_HashAppend appends data to hash
· xp_HashClose returns hash value and then closes the hash handle
· xp_md5_quick returns MD5-hash on a given value
· xp_md5_quick_compare checks if a given value is OK to a given MD5-hash
· xp_sha_quick returns SHA-hash on a given value
· xp_sha_quick_compare checks if a given value is OK to a given SHA-hash
· xp_symmetric_quick_encode encodes data with password using either RC2, RC4 or DES algorithm
· xp_symmetric_quick_decode decodes data protected with password using either RC2, RC4 or DES algorithm
· xp_GetRandomData returns a random bytes value of the specified length


These procedures are provided by a dynamic-link library, xpCryptUtils.DLL.