In Sql server 2005 we can Encrypt & decrypt our data using this function.
// For Encryption
EncryptByPassPhrase(‘Key Value’,'Text’)
// For Decryption
cast(DecryptByPassPhrase(‘Key Value’,Encrypted Text) as varchar(16))
Key Value :- Value Of Key That is use For Encryption & Decryption Process.
Text :- In That Perameter Pass the Text That can be Encrypt.
