Swap the Values of Two Columns in SQL Server

18 Mar 2024

Intermediate

6.11K Views

3 min read

Learn via Video Course & by Doing Hands-on Labs

SQL Server Course

Free Course Self Paced Courses Hands-On Labs Interview Q&A

Swapping Values of Columns in SQL Server: An Overview

Suppose you want to swap the values of two columns of a table in SQL Server, how could you achieve this tricky task? It is simple and so funny.

How to Swap Values of Two Columns of a Table in SQL Server?

Suppose you have a Customer table in the database with the following data and you want to interchange the values of columns, Name and Address then how do you do it?

Read More: Basics of SQL Commands


 SELECT * FROM CUSTOMER

Output

Don't worry, to do this task, you need to just write a simple update query for the Customer table like as:


 UPDATE Customer SET Name=Address , Address=Name

Now after query execution, you will find that the values of columns, Name, and Address have been interchanged, that's so cool.


SELECT * FROM CUSTOMER

Output

Note

The data type of both columns should be the same and also the length should be enough to hold the swapped column data the data will be truncated.

What do you think?

I hope you will enjoy this trick while having fun with SQL Server. I would like to have feedback from my blog readers. If you want to gain a practical understanding, you can enroll in our SQL Server Course.

Do you Know?

.NET is gaining popularity day by day, especially after the release of .NET 8. .NET 8 is not only a framework version but much more than that. It redefines the way software applications are built and deployed, enabling developers to meet the evolving demands of modern computing.

Therefore, if you want to upskill yourselves and stand out from others consider our following training programs on .NET.