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

create table san(empid int,empname varchar(10))
insert into san values(1'san')
update san set empid=empname,empname=empid

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dbcc command in sql server?

1016


What are commonly used mssql functions in php?

994


What is sql server transaction log file?

990


What is data compression? : sql server database administration

916


How to backup encryption key ?

167


How do I view a trc file?

897


Write a program to fetch first 10 records from a file?

960


Please differentiate between a local and a global temporary table?

948


What is the primary use of the model database?

1017


What is shrink log file?

839


Where are sql server user names and passwords stored in sql server?

1014


Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

940


What is a database in ms sql server?

989


What is a trace frag? Where do we use it?

1043


What is difference between index seek vs. Index scan?

1091