Swap column values in SQL

Create table as tblSwap as shown in bellow

create table tblSwap

(

       EmpID int,

       EmpName varchar(20),

       City varchar(20),

       Country varchar(20)

)

GO

and insert new records in table using bellow script

insert into tblSwap

values(1,'Ram Kumar','India','Hyd')

insert into tblSwap

values(2,'Rayudu','UAE','Dubai')

insert into tblSwap

values(3,'Mani','India','Viz')

insert into tblSwap

values(4,'Sarath','USA','Boston')

select * from tblSwap

In my results, data got inserted in wrong columns as mentioned bellow

city data in country column and county data in city column

By using bellow query we can swap data to correct columns

select * from tblSwap

GO

update tblSwap

set City=Country

,Country=City

GO

select * from tblSwap