test

http://a499.phobos.apple.com/us/r1000/026/Music6/v4/ee/1c/8e/ee1c8eea-cbfc-2984-db5e-5c4f2cf7c8c0/mzaf_3865492851037958779.plus.aac.p.m4a

Encrypted Field

The steps to encrypt a field is easy, full details are here

CREATE MASTER KEY ENCRYPTION BY

PASSWORD = 'your password here'

GO

CREATE CERTIFICATE EncryptTestCert

    WITH SUBJECT = 'name'

GO

CREATE SYMMETRIC KEY cryptoKey

    WITH ALGORITHM = TRIPLE_DES

    ENCRYPTION BY CERTIFICATE EncryptTestCert

GO

To get encrypted content

OPEN SYMMETRIC KEY cryptoKey

DECRYPTION BY CERTIFICATE EncryptTestCert

ENCRYPTBYKEY(KEY_GUID('cryptoKey'),@input) 

To get decrypted content

OPEN SYMMETRIC KEY cryptoKey

DECRYPTION BY CERTIFICATE EncryptTestCert

CONVERT(nvarchar(Max), DecryptByKey(fieldName))