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
