HOW TO ENCRYPT AND DECREYPT PASSWORD BY USING ENCRYPTBYPASSPHRASE AND DECRYPTBYPASSPHRASE IN MSSQL

HERE IN THIS SQL Tutorial WE WILL ENCRYPT AND DECREYPT PASSWORD BY USING ENCRYPTBYPASSPHRASE AND DECRYPTBYPASSPHRASE IN MSSQL

HERE WE REQUIRED
ENCRYPTBYPASSPHRASE
DECRYPTBYPASSPHRASE

[zerosandones]

we can always replace the 8 with any value (string or number) right?

[anuanitha]

Is this possible to decrypt the password without encrypted in mssql that means encryption was done by using java(MD5) algorithm

[wishbone]

I didn't get the code line of decrypting