by certificate, symmetric key, asymmetric keys to the database table field (column) after encryption (EncryptByKey), Create a VIEW (the Create VIEW.. Select DecryptByKey ([field name] from [table])),
If you want to view data search, must perform t-sql: before the OPEN SYMMETRIC KEY (to OPEN the KEY or certificates), and then select the view would show clear, bosses, how don't have to OPEN the KEY or certificate first, searchable view clear data, and don't have to add about the OPEN view in SQL SYMMETRIC KEY SQL script, prevent found certificate KEY,