Showing posts with label Swap the values of two columns in SQL Server. Show all posts
Showing posts with label Swap the values of two columns in SQL Server. Show all posts

Wednesday, August 13, 2014

Swap the values of two columns in SQL Server



SELECT * FROM CUSTOMER

UPDATE Customer SET Name=Address , Address=Name

SELECT * FROM CUSTOMER