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 defragment table indexes?

931


How to call stored procedure using http soap?

998


How do I open port 1433?

880


What is implicit cursors?

1002


What does the update command do?

1050


When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1050


What are the tables in sql?

1038


What is the correct order of the logical query processing phases?

873


What are the steps to take to improve performance of a poor performing query? : sql server database administration

978


What is user-defined inline table-valued function?

898


you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

890


Tell me in brief how sql server enhances scalability of the database system?

938


How to change the password of a login name in ms sql server?

959


Can we join two tables without primary key?

979


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1945