Question:

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

Answer:

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

swap column values in sql - rajanand.org.png