forum

Home / DeveloperSection / Forums / How to Swap the values of two columns in SQL Server.

Ask Question

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

Anonymous User 1463 03-Mar-2016

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

sql server

Updated on 03-Mar-2016

Anonymous User

I am a content writter !

Can you answer this question?

Answer

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]INTIDENTITY (1, 1)NOTNULL,
[EmpName]VARCHAR (50)NOTNULL,
[Salary]DECIMAL (18)NOTNULL,
[DeptName]VARCHAR (50)NOTNULL,
[Designation]VARCHAR (50)NOTNULL,
PRIMARYKEYCLUSTERED ([EmpNo]ASC)
);select*from[Employee]
 
 
updateEmployeesetDesignation=DeptName,DeptName=Designation
 
select*from[Employee]

forum

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

Anonymous User

1 Answers

Liked By