select menu from (select m_name as menu from m_master) a union select m

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

Question Posted / dinesh

Answer Posted / dinesh

select menu from (select m_name as menu from m_master) a
union select m_name as menu from db2 .dbo.m_master

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to set a database state to offline in ms sql server?

1040

What is relationship? What number of sorts of relationship are there?

1133

List the types of recovery model available in sql server?

923

How can a database be repaired?

986

How except clause is differs from not in clause?

949

What is the difference between update lock and exclusive lock?

971

How many replicas are maintained for each sql azure db?

124

What are the different subsets of sql?

1548

How to automatically create a log when an exception is being received into SQL Server?

1283

Define Wed Edition in SQL Azure?

100

what is the primary use of the model database? : Sql server administration

1044

What is default constraint in ms sql server?

1026

Why use triggers?

1009

Why do we use trigger?

961

What is SQL Azure Data sync?

121