Swap values of two columns in sql server

Hi ,
        Suppose In case of data uploading or data inserting you done mistake to upload or insert
data of one column to other then you want to swap the values of that two columns of a table
in SQL Server.
Suppose you have a #emp_info table in the database with the following data and
you want to interchange the values of empno and then how do you do?

r
create table #emp_info (empno int,ename varchar(100),manage_id int)

insert into #emp_info (empno,ename ,manage_id )values(1,'sandip',3)
insert into #emp_info (empno,ename ,manage_id )values(2,'harshal',1)
insert into #emp_info (empno,ename ,manage_id )values(3,'aditya',4)
insert into #emp_info (empno,ename ,manage_id )values(4,'pranav',2)
insert into #emp_info (empno,ename ,manage_id )values(5,'ajit',3)

Your Data ::

select * from #emp_info

Don't worry, to do this task, you need to just write a simple update query for Customer table like as :

UPDATE #emp_info SET empno=manage_id , manage_id=empno

Other Popular Posts ::

Take Back up of table using select statement in sql server
Column data in comma seprated string
Delete duplicate records from table
Date function in sql server
Sql server::String with initial letter in uppercase.
Dynamic Query in sql server
Basic About View
send sql table data via email using store procedure
How to use Store Procedure inside a store procedure
SET ANSI_NULLS in sql server
SET QUOTED_IDENTIFIER in sql
example of Cursor in sql server
basic of Cursor in sql.
delete duplicate records in sql server
select duplicate records in sql server
update duplicate records in sql server
comman table expression(CTE) in sql server
Split Funtions in sql server
Sql queries for sql server
Trigger on Update
Trigger on insert
trigger on delete
basic of trigger