Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

How to Swap the values of two columns in SQL Server.

Anonymous User 1722 03 Mar 2016

We want to Swap the values of two columns in SQL Server. How to do this please Help me.

Anonymous User

Other

I am a content writter !

1 Answers

Anonymous User 03 Mar 2016

When you want to swap the values of two columns of a table in SQL Server, how could you achieve this tricky task?.

it is simple like code below.

 CREATE TABLE [dbo].[Employee] (
    [EmpNo]       INT  IDENTITY (1, 1) NOT NULL,
    [EmpName]     VARCHAR (50) NOT NULL,
    [Salary]      DECIMAL (18) NOT NULL,
    [DeptName]    VARCHAR (50) NOT NULL,
    [Designation] VARCHAR (50) NOT NULL,
    PRIMARY KEY CLUSTERED ([EmpNo] ASC)
);
select * from [Employee]
 
 

update Employee set Designation=DeptName,DeptName=Designation
 
select * from [Employee]

MindStick Training