SQL interview question Part-2

 Note :  All sql related question related to SQL Server.

(1) In SQL : How to swap column values​​ ?

Ans : 
update #tempSwap set EMPNAME = DEPT,DEPT = EMPNAME;