I want to encrypt and decrypt the all columns in the table.
With the following i m able to encrypt/decrypt only one column in the table.
Procedure to Insert Data in Table
-- Procedure to Retrive Users
Please help me to encrypt/decrypt all the columns in the table. Thank you
A later question (duplicate; now closed) was asked by the same person with the following additional comment:
What you're describing isn't TDE.
This will encrypt everything in your database file. You can still read it, but the file and backups will now be encrypted - no-one will be able to access your data except through proper db connections.
answered Mar 14 '10 at 05:08 AM
If you have some reason why you don't want to use TDE, then you are stuck applying the encrypt functions to each column individually, effectively repeating the type of code you already have.
answered Mar 14 '10 at 07:49 PM