GilaMonster (7/15/2014)
No. T-SQL, with the T-SQL encryption functions like EncrypByKey and DecryptByKey, or whichever of the similar functions you identify as meeting your requirements for protection, key management and all the rest of the admin around encryption.You certainly can do it in .Net if you want with whatever the .Net encryption functions are.
Thank you very much! 🙂
So I can do it in T-SQL?
Do you have an example where you had to encrypt and decrypt the SSN or TAX ID Number please.
The following article threw me off.
http://msdn.microsoft.com/en-us/library/ms174361.aspx">
http://msdn.microsoft.com/en-us/library/ms174361.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/