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

What is a derived table?

923

Explain contrast amongst grouped and non-bunched records?

1012

New concepts of sql server 2005 use in your project.

2357

Do you know what are various aggregate functions that are available?

1114

What is report subscription?

123

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1042

How to execute the cursor queries with "open" statements?

1175

What is the beast way to write CTE in SQL Server ?

1039

What are the differences between left join and inner join in sql server?

1102

What is the federation in sql azure?

Explain few of the new features of sql server 2008 management studio

908

What is a primary index?

919

What is order of B+tree?

1105

What is a mutating table error and how can you get around it?

1040

What is ssl in sql server?

1069