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 what are various ways to enhance the ssrs report?

1011

What is the difference between mysql and sql server?

961

Can you create a logon trigger in sql server 2005 express edition?

1047

Can we check locks in database? If so, how can we do this lock check?

911

What are the properties of the transaction?

975

explain the storage models of olap? : Sql server database administration

907

Define the one-to-one relationship while designing tables.

874

What is sql server database?

960

Define views.

979

Write a program using SQL queries to find a unique entry in a table.

956

how to use DTS package in 2000,2005,2008 in sql server

1803

What is acid mean in sql server?

1069

what is the difference between openrowset and openquery?

1043

What is field with example?

886

What is mean by dml?

966