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 is scheduled job and how to create it?

542

What is Service Broker in sql server 2012?

616

What is the maximum number of index per table?

560

Write a program to fetch first 10 records from a file?

598

How to turn off warning messages during php execution?

523

How do you troubleshoot errors in a SQL Server Agent Job?

554

Why does sql studio use a single registered database repository? : sql server management studio

523

Explain log shipping?

579

Do you know clustered and non-clustered index?

518

What is difference between sql and sql server?

538

Do you know sql server 2008 backup compression?

564

Explain a join?

606

What is the maximum size of sql server database?

499

What is the sql case statement used for?

557

Please illustrate physical database architecture? : SQL Server Architecture

526