For example, "x" and "z" occur 0.245% of the time, so they get swapped. Apparently, the distribution of characters in names is different than it is for normal conversational English. I use a method that changes characters in the name to other characters that are in the same "range" of usage frequency in English names.
#Unscramble decibel how to
Some of the answers are what I am attempting to do, to 'switch' the names, but my question is literally, how to code in T-SQL?
This data will also be used in our sales & demo environments which are publicly available. UPDATE: Never fails, you try to put all the information in the post, and you forget something important. This worked well in test, but completely bogs down dealing with larger amounts of data (>20 minutes for 40K rows)Īll of that to ask, how would you scramble customer names while keeping real names and the weight of the production data? UPDATE SET LastName=(SELECT FROM WHERE ROWID=Id) (SELECT ROW_NUMBER() OVER (ORDER BY NEWID()) AS ROWID, LastName FROM Customer) INSERT SELECT LastName FROM Customer ORDER BY NEWID() * Scramble the last names (randomly pick another last name) */ Like this: DECLARE TABLE (Id int IDENTITY(1,1), varchar(100)) What I have tried so far is building a temp table of all last names in the table then updating the customer table with a random selection from the temp table. I want to keep real names so we can still use or searches so random letter generation is out. But I've come up against a wall trying to scramble customer names. I've built a couple of scripts that make random social security numbers, shift birth dates, scramble emails, etc. I'm looking for a homegrown way to scramble production data for use in development and test.
0 kommentar(er)
