Monday, March 04, 2013 5:56 AM
currently i have a table with 80 crore rows data ,I need to obfucate the data in some columns for eg:-If name is 'David Peter' (Same name is used in differnet rows),then i need to update it with some other values like 'ytfr trey'.Now what we do is we have a table with column data like 'ytfr trey' and we are updating randomly the in the table based on rownumber function but this take so much of time .So what i need is a sql query having the logic to update like this eg:-If ABCD is name then i need to update it with CDEF ie two letter difference or some different name but query should update data fastly
Monday, March 04, 2013 7:07 AMUse REPLACE...
Monday, March 04, 2013 7:11 AM
You can use a column level encryption, where in you would have to create a key for the database.
you can read about it here:
- Marked As Answer by Iric WenModerator Tuesday, March 12, 2013 7:47 AM
Monday, March 11, 2013 4:13 PMModerator
Article on obfuscation:
Kalman Toth Database & OLAP Architect
Paperback / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012