Please enable Javascript to correctly display the contents on Dot Net Tricks!

Swap the values of two columns in SQL Server

  Author : Shailendra Chauhan
Posted On : 07 Nov 2012
Total Views : 134,994   
Updated On : 26 Sep 2016
 

Do you have fun with SQL Server?. Let's start fun with SQL Server. Suppose you want to swap the values of two columns of a table in SQL Server, how could you achieve this tricky task?. Actually, it is simple and so funny.

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?

 SELECT * FROM CUSTOMER 

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

 UPDATE Customer SET Name=Address , Address=Name 

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

 SELECT * FROM CUSTOMER 

Note

  1. Data type of both the columns should be same and also length should be enough to hold the swapped column data other wise 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. Your valuable feedback, question, or comments about this article are always welcome.



Free Interview Books
 
COMMENTS (0)
23 MAY
Xamarin Forms : Build Cross-platform Apps (Online)

09:00 PM-11:00 PM IST(+5.30 GMT)

Know More
5 MAY
ASP.NET MVC with Angular4 Development (Online)

06:30 AM-08:30 AM IST(+5.30 GMT)

Know More
29 APR
Xamarin Forms : Build Cross-platform Apps (Classroom)

5:00 PM-6:30 PM

Know More
29 APR
ASP.NET MVC with Angular2 Development (Classroom)

9:30 AM-11:00 AM

Know More
27 APR
ASP.NET Core Development (Online)

07:00 AM - 09:00 AM IST( TUS, THR)

Know More
22 APR
NodeJS Development (Classroom)

11:00 AM-12:30 PM

10 APR
Master Class ASP.NET MVC 5 with Angular2 Plus Angular4 Development (Online)

09:00 PM - 11:00 PM IST (M/W/F)

8 APR
MEAN Stack 2 Development (Classroom)

11:00 AM-12:30 PM

25 MAR
Xamarin Forms : Build Cross-platform Apps (Classroom)

8:00 AM-9:30AM

21 MAR
ASP.NET MVC with Angular2 Development (Online)

09:00 PM - 11:00 PM IST( TUS, THR, SAT)

25 FEB
ASP.NET MVC with Angular2 Development (Classroom)

03:30 PM-05:30 PM

24 FEB
Angular 2 with Type Script (Online)

09:00 PM-11:00 PM IST(Mon,Wed,Fri)

BROWSE BY CATEGORY
 
 
LIKE US ON FACEBOOK
 
+