select names from (select full_name as names from table 1) a union sele

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

Question Posted / dinesh

Answer Posted / dinesh

select names from
(select full_name as names from table 1) a
union
select full_name as names from table 2

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is an example of a primary key?

1037

What is query optimization process?

1081

What is a trigger in sql server?

1229

Explain what role entity and relationship play in an ER diagram.

1111

How can you find out how many rows returned in a cursor?

1086

What are different types of constraints?

970

What is the difference between varchar and nvarchar?

987

What is entity data services?

1117

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

1039

What are alternate keys?

1031

Do you know what is user defined datatypes and when you should go for them?

1010

Does hive support indexing?

1001

Can you move the resources after pausing the node? : sql server database administration

1167

What is the definition for sql server 2000?

1139

Explain the etl (extraction, transformation, and loading)?

1053