Developer Bloq

Mssql 2005 has provides a lot of encrption function: PassPhrase, synrommetric, asymmetric and encryption by certificate.
PassPhrase function is basicaly method for data encryption. It’s use e user defined decryption key.

Encrypting data by PassPhrase:

Declare @EncryptedData varbinary(MAX)
Select @EncryptedData = EncryptByPassPhrase('cenq', 'mypassword' )
Select @EncryptedData

Decrypting data by PassPhrase:

Declare @DecryptedData nvarchar(36)
Set @DecryptedData = Convert(VarChar(36),DecryptByPassPhrase('cenq', 0x010000000F11B98B5BC8D062F57F404B59C12B0084EF898ABFCC7477F47C99BCF1259C00))
Select @DecryptedData

Output:

mypassword