Swap Two Columns Values in SQL Server

In this blog, You will see how to swap two columns values in SQL Server.

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