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 the usage of sign function?

1095

Why are views required in the sql server or in any other database?

948

what is a traditional network library for sql servers? : Sql server database administration

947

Describe in brief sql server monitoring ways.

1048

List the different normalization forms?

970

What is table-valued sub query?

957

What is trigger and different types of Triggers?

1138

Explain what are the database objects? : SQL Server Architecture

1071

What does the not null constraint do?

1076

What is the difference between stored procedure and user defined functions?

1182

How can i Relate Tables in SSIS

1076

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

964

what is the difference between openrowset and openquery?

1077

What are the built in functions in sql server?

976

Which table keeps the locking information?

915