The requirement is that the data in certain columns need to be encrypted after data is loaded and later on need to be decrypted so that these values can be used in calculations in a stored proc. My questions are :- Do I add new columns to the existing table to hold encrypted data in varbinary or something? What can be the appropriate data type that can hold both the encrypted value and the value after decryption in the same column?
asked Apr 18, 2014 at 05:29 AM in Default
If you're going to encrypt individual columns (not something I've done personally), I've always seen it done as binary storage.
answered Apr 22, 2014 at 10:05 AM
Grant Fritchey ♦♦