Encryption & Decryption Using SQL Server 2005

  1. 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.                             


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s