create table san(empid int,empname varchar(10)) insert into san values(1&#

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

Question Posted / san

Answer Posted / san

create table san(empid int,empname varchar(10))
insert into san values(1'san')
update san set empid=empname,empname=empid

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is the difference between createstatement and preparedstatement?

942

Write a sql query to display the current date?

1094

What is delete query?

941

What is a cube? : sql server analysis services, ssas

999

What is 4nf in normalization form?

1026

How to store and query spatial data?

993

Explain logical operators in sql server?

1110

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

989

Does union all remove duplicates?

1066

What is mapping schema?

1028

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1062

Explain try...catch with sql server?

1024

Where to find ntwdblib.dll version 2000.80.194.0?

962

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

952

What is “asynchronous” communication in sql server service broker?

1034