SQL SERVER PASSWORD ENCRYPT

SELECT PWDENCRYPT('ARKA')

SELECT HASHBYTES('SHA1','ARKA')

SELECT EncryptedData = EncryptByPassPhrase('My$ecret|, 'ARKA' )

-- DecryptByPassPhrase(@password,@DataToDecrypt )

DECLARE @VAL VARBINARY(MAX)

SET @VAL = 0x010000007C81A89DF4E176FFA8C75FB3D0222B8D3004752A17A57C43

SELECT CONVERT(VARCHAR(100),DecryptByPassPhrase('My$ecret|,@VAL))