• Good question. In real world, I always use temp table to swap the columns. May be just not want to take risk of data mess.