what should be the query for this ?
how do I swap records in SQL . I have a case in which I have to swap records of one employee to other , for example I have to update like " **A's hat on B's head and B's hat on A's head**" .
Only I need the query , i have the fields.


what should be the best approach for this? Is there any easy query for this ?
what should be the query for this ?
===

how do I swap records in SQL . I have a case in which I have to swap records of one employee to other , for example I have to update like " **A's hat on B's head and B's hat on A's head**" .
Only I need the query , i have the fields.


what should be the best approach for this? Is there any easy query for this ?