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

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

2103


what is denormalization? : Sql server database administration

920


How to define the name and server for a new dsn?

1106


What is microsoft sql server?

965


What are the three different part of rdl file explain them?

265


How to invoke a trigger on demand?

1085


What is replication with database mirroring? : sql server database administration

1070


what is the difference between a primary key and a unique key? : Sql server database administration

994


How many types of subqueries are there in sql server?

987


Find columns used in stored procedure?

987


Does partitioning help performance?

931


What is pessimistic concurrency?

970


What is a view in sql?

973


Do you know what is blocking?

948


What are trace flags and mention a few common trace flags used with sql server?

1080