Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

How to update muliple row in single query?

1011


What are the 2 types of classifications of constraints in the sql server?

1063


What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

918


What is the maximum size of sql server database?

959


Do you know what are different types of replication in sql server?

1052


Explain about system database?

1012


What is user-defined inline table-valued function?

912


What is wrong with sql server client libarary dll, ntwdblib.dll?

1007


Can we call future method from trigger?

891


Explain the stored procedure?

1001


What is an identity column in insert statements?

981


Does sql server use java?

1013


What is a database table?

937


Mention a few common trace flags used with sql server?

896


How do you start single user mode in clustered installations?

911