emp table has
PK First_Name Last_Name among other data
there 5000 rows there, and this is a test server.
there is a need to hide the identity of the employee, and yet allow it to look normal.
the logic needed is
the first and last name should be ordered randomly and assigned randomly to the PKs.
PK 1 might have been John Adams.
this John may go to PK 386 and the Adams part may go to PK 4098 and in return,
PK 109's Mary may get to PK 1's first name, and PK 2034's Last name Cooper may come to PK1.
And thus it has to be updated through code-
reverting back is not needful.
how would you do this in tsql?