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.
Reference: Pinal Dave (http://blog.SQLAuthority.com)
