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
What is the template in sql?
How to connect sql server management studio express to sql server 2005 express?
How to sort query output in descending order in ms sql server?
What is entity data services?
What is correlated subquery in sql server?
How to drop an existing schema in ms sql server?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What is transaction server auto commit?
what is a correlated sub-query? : Sql server database administration
How to loop through result set objects using odbc_fetch_row()?
Can we call future method from queueable?
How to get a list of columns using the "sys.columns" view in ms sql server?
How to set the current database in ms sql server?
How to scale out a federation by Sql statement?
How much space does sql server 2016 take?