How to swap column value in SQL? - Rajanand

Question:

Write an update statement to swap the column values without using a temporary tables. Before Update:

After Update:

Answer:

UPDATE dbo.STUDENT
SET first_name = last_name,
	last_name = first_name;

swap column values in sql - rajanand.org.png