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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the template in sql?

532


How to connect sql server management studio express to sql server 2005 express?

572


How to sort query output in descending order in ms sql server?

535


What is entity data services?

573


What is correlated subquery in sql server?

552






How to drop an existing schema in ms sql server?

587


you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

705


What is transaction server auto commit?

569


what is a correlated sub-query? : Sql server database administration

477


How to loop through result set objects using odbc_fetch_row()?

461


Can we call future method from queueable?

586


How to get a list of columns using the "sys.columns" view in ms sql server?

551


How to set the current database in ms sql server?

519


How to scale out a federation by Sql statement?

92


How much space does sql server 2016 take?

565