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

Question

Anonymous User · Answer

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 simpleand 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]and and 
update Employee set Designation=DeptName,DeptName=Designationand select * from [Employee]and and and and

forum

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

Anonymous User

Can you answer this question?

1 Answers

Liked By