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

When would you use a before or after trigger?

858

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8109

what's the information that can be stored inside a bit column? : Sql server database administration

965

What is faster join or union?

1108

how to determine the service pack currently installed on sql server? : Sql server database administration

907

What is the use of custom fields in report?

946

What happens if you insert a duplicate key for the primary key column in ms sql server?

933

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

988

how to take backup bcp out for a column in table in sql server?

2044

Explain error and transaction handling in sql server?

953

How to use subqueries with the in operators in ms sql server?

1008

How to create function with parameter in sql server?

1039

What are translations and its use? : sql server analysis services, ssas

993

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

893

What is Dependency Injection and provide example?

1040