In this blog, You will see how to swap two
columns values in SQL Server. Here, we create a table and using update command
to swap two columns values.
Creating a table in SQL Server
Now we create a table named employee:
Create
table
Employee
(
EmpID
int,
EmpName
varchar(30),
EmpSalary
int
)
The following is the sample data for the employee
Table:
Now using Update command to swap Columns Values
(Empid, EmpName).
Using Update command
update
employee
set
Empid=EmpSalary,
EmpSalary
=empid;
select
*
from
employee
Output