Swapping column value in sql

Question

How can I swap column value in sql.

Pradip Pandey · Answer

Hi Sharad Suppose there is a table called with fileds EmpID int FirstName varchar(50) LastName varchar(50) You added some records like this Insert into Employee(EmpIDFirstNameLastName)Values(1'Rajput''Manoj') Insert into Employee(EmpIDFirstNameLastName)Values(2'Sharma''Gaurav') Insert into Employee(EmpIDFirstNameLastName)Values(3'Verma''Deepak') Actually you added records wrongly. Now by this sql statement you can swap column value in sql UPDATE Employee SET LastName=FirstName FirstName=LastName