UPdate temp set col1=col2, col2=col1

How to swap the data of two columns in a table. both the
columns containing varchar values.

Question Posted / nilesh

Answer Posted / nilesh

UPdate temp
set col1=col2,
col2=col1

Is This Answer Correct ?

21 Yes

15 No

Please Help Members By Posting Answers For Below Questions

Explain the microsoft sql server delete command?

949

How to delete existing rows in a table?

1071

what is a live lock? : Sql server database administration

888

What are the different type of replication in sql server?

933

How to truncate the log in sql server 2012? : sql server database administration

1199

What are the properties of primary key?

913

How to use union to merge outputs from two queries together in ms sql server?

1006

How to enter unicode character string literals in ms sql server?

1017

Difference between report and query parameter.

1023

What does <> symbol mean?

918

List out the different types of locks available in sql server?

932

Is natural join and equi join same?

910

How to add more data to the testing table in ms sql server?

1000

What is the difference between dropping a database and taking a database offline?

1115

Explain the phases a transaction has to undergo?

985