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

Explain atomicity?

1127

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1254

How to throw custom exception in Stored Procedure?

1095

What is an index. What are the types?

1161

Define outer join in sql server joins?

990

Can you tell me some of the common replication dmv's and their use? : sql server replication

975

Difference between report and query parameter.

1144

How can we check the sql server version?

1126

What is database replication?

1209

What is data file in computer?

1000

Why functions are used in sql server?

1016

What are the differences between char and nchar in ms sql server?

1143

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

978

How to turn off warning messages during php execution?

1106

How to search for a string in all stored procedure in sql server?

1054