How to Swap Column Values in SQL Server?
Please use the below-shown query to swap two column values
-- Query to Swap Two Column Values in SQL Server USE [SQL Tutorial] GO UPDATE [dbo].[EmployeeDuplicates] SET [Education] = [Occupation], [Occupation] = [Education] GO
Let me show you the updated records. From the below screenshot, you can see that the information in the Education column stored in Occupation Column. And data inside the Occupation column is stored in the Education column.