If I use
ENCRYPTBYPASSPHRASE to encrypt the full table then how can I decrypt full table easily by using
Actually I have to use
DECRYPTBYPASSPHRASE ('passphrase', column_name) for every column to decrypt it. So it becomes so lengthy command. If I want to decrypt all columns then I have to specify this statement for all columns. Instead of that, can I use
DECRYPTBYPASSPHRASE in queries so that I can use it only once and it decrypts all the columns?