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 raid? : Sql server database administration

545

what are database files and filegroups? : Sql server database administration

495

Explain the different types of backups available in sql server? : sql server database administration

512

How to send a ssrs report from ssis?

125

Explain having clause?

526

What is collation?

713

Write a sql query to sort on different column name according to the parameters passed in the function?

522

What is the concept of optimization?

559

What are the dmvs?

558

What do you understand by check constraint in sql server?

476

How to replace given values with null using nullif()?

568

Can sub report data source be different from that of the parent report?

105

how you can list all the tables in a database?

519

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

523

What is TDS(Tabular Data Stream) Gateway?