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

What are the differences between union, intersect, and minus operators?

1086


How can I know what locks are running on which resource?

957


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2483


why would you use sql agent? : Sql server database administration

1210


What are the advantages of policy management?

997


A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

961


How do I run sql server 2014?

998


I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1089


Why I have to use stored procedures?

1038


what stored procedure would you use to view lock information? : Sql server administration

971


Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

118


What is difference between createstatement and preparedstatement?

1090


What does <> symbol mean?

974


How to create an index on a view?

1069


Can we write ddl in trigger?

918