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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / amit kumar

Answer Posted / amit kumar

select Col1,col2 into newtable

Is This Answer Correct ?    0 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is candidate key with example?

922

Who is the owner of a schema in ms sql server?

1007

Do you know spatial data types - geometry and geography in sql server 2008?

968

What is ssrs?

117

Name some of the open source software that you can use in alternative to SSR?

151

What are the joins in sql server? : sql server database administration

961

How to read data in a table with "select" statements?

917

What is an expression in ms sql server?

1008

What does normalization do to data?

988

How to change the system date and time from SQL Plus Terminal ?

1151

What is the security model used in sql server 2005?

932

What is dbcc updateusage?

1150

Can you roll back the ddl statement in a trigger?

912

What do you understand by the denormalisation?

907

What is the difference between varchar and nvarchar datatypes?

1032