Last post Jan 23, 2019 02:43 AM by Wei Zhang
Jan 22, 2019 05:15 PM|ahsan|LINK
I have a regular ASP.Net website (Framework 2.0) connected with SQL Server 2016.
Website functionality grab CSV files and dump data into SQL tables.
Before inserting CSV data, front end encrypts certain columns. One column is cost.
To produce a web report, we have to manipulate SQL table ‘Cost’ column in a store procedure. As cost column is encrypted and doesn't allow me to manipulate.
Wondering how should I approach this matter! If I think to share front end encryption key into a store procedure, back-end data can be decrypted.
Thanks in advance for any kind of tip and tricks.
Jan 23, 2019 02:43 AM|Wei Zhang|LINK
Hi ahsan ,
Generally speaking, if users want to modify the encrypted data in the database, they usually encrypt the new data and then updating the data in database.
However it is nothing to prevent you from decrypting data in Sql Server side.Since sqlserver could run .exe file written by c# , I suggest you to create a .exe program to decrypt data and run it in sql server side, then you could update
the data you want.