January 2, 2014 at 11:05 pm
Hi All,
I have an requirement that, i have to Encrypt Salary's Information in my database. Basically, it has Employee's Salary Break Up details like LTA, Basic, Special Pay....
So from the above one, i need to Encrypt all the Salary's Information and Decrypt the same when it required. I have seen some Built in Functionalists say EncryptByPassPhrase, EncryptByKey....
Can you please suggest me, Are there any other way where i can do this Encryption?
Thanks All....
January 5, 2014 at 6:10 pm
You are right, there are built in functions. I can't imagine why you would not use them, but the only sensible alternative is to use the Cryptography namespace in C#, and follow this:
http://technet.microsoft.com/en-us/library/ms345136(v=sql.90).aspx
to use CLR code inside SQL Server.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply