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