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 information that can be stored inside a bit column? : Sql server database administration

920

Do you know what is a trace frag? Where do we use it?

967

How do we synchronize On-Premise SQL server with SQL Azure?

120

How many non clustered indexes there can be on table ?

873

What is the openxml statement in sql server?

1024

Write a SQL query to delete a table?

1092

How to delete an existing database user?

977

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

956

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

933

what are the different stages of Report Processing?

129

How to write a query with a right outer join in ms sql server?

880

Can we use custom code in ssrs?

1074

Can you force a query to use a specific index?

899

What is difference between global temporary tables and local temporary tables?

1188

Which language is supported by sql server?

970