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

Answer Posted / nilesh

UPdate temp
set col1=col2,
col2=col1

Is This Answer Correct ?    21 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to enable tcp/ip protocol on a sql server?

1161

Can you pass expressions to function parameters?

1103

What is the difference between functions and scalar functions?

1210

What are the advantages dts has over bcp?

1000

How to use subqueries with the exists operators in ms sql server?

1119

How does a profiler work?

929

What is the full meaning of dml?

952

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

2147

Can we insert data into view sql server?

927

What does it mean to be in union?

934

Differentiate between delete and truncate.

1062

How will you monitor replication latency in transactional replication? : sql server replication

1143

Can a database be shrunk with users active?

1133

What is difference between cte and view?

917

What are the features of Embedded SQL

1127