Today we will see a quick video on how to swap columns in SQL Server. It is a widespread request. Think of the scenario where you have a form with first name and last name. Now users have input the data in a different order than you expect. In this case, you can easily swap the value of both the columns; that is what we will learn in this video.
Here are my few recent videos, and I would like your feedback about them. Do not forget to subscribe SQL in Sixty Seconds series. I hope you appreciate learning about the last few SQL in Sixty Seconds Video.
- Indexing for Delete – SQL in Sixty Seconds #197
- Compressed Backup and Performance – SQL in Sixty Seconds #196
- Find Missing Identity – SQL in Sixty Seconds #195
- Remove Key Lookup – SQL in Sixty Seconds #194
- Using Stored Procedure in SELECT – SQL in Sixty Seconds #193
- Performance Troubles – Function on Date Variable – SQL in Sixty Seconds #192
- Performance: Between and Other Operators – SQL in Sixty Seconds #191
- Most Used Database Files – SQL in Sixty Seconds #190
Well, that’s it for today. Would you like me to build a video on this topic? If yes, let me know, and I will build a video on this topic on my SQL in Sixty Seconds channel.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
Discover more from SQL Authority with Pinal Dave
Subscribe to get the latest posts sent to your email.
