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 meant by indexing files?

1042

What are the different types of join?

1173

What is log ldf?

983

What happens if null values are involved in string operations?

992

What is the purpose of grouping data in a report?

968

Explain the stored procedure?

1053

What do you understand by recursive stored procedure?

930

How do I create a trace in sql server?

1042

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

944

What are locks in sql?

981

How you can change the database name in SQL SERVER?

1192

What is an indexing strategy?

1010

What are the export options of ssrs?

173

How can you insert values in multiple rows using one Insert statement?

1098

What are the advantages of user defined function?

985