Swap Two Columns Values in SQL Server

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

Introduction

In this blog, You will see how to swap two column values in SQL Server. Here, we create a table and swap two columns' values using the update command.

Creating a table in SQL Server

Now, swap Columns Values (Empid, EmpName) using the Update command. 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.

 

Using Update command

update employee set Empid=EmpSalary, EmpSalary =empid;
select * from employee

Output