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

Is it possible to update the multiple field values in a
single query? If possible then write the actual query.

Answer Posted / manjiri

update table_name
set col1=new_value, col2= new_value...
where condition/'s

Is This Answer Correct ?    14 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What the different topologies in which replication can be configured? : sql server DBA

1314


How can you control the amount of free space in your index pages? : sql server DBA

1372


how can you implement fine-grained auditing?

1198


What are the different types of indexes available in sql server? : sql server DBA

1259


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2664


how can you get actual data change values from previous transactions in oracle?

1137


What are the different sql server versions you have worked on? : sql server DBA

1066


What are the commands you'd issue to show the explain plan for "select * from dual"?

2268


how does an oracle clusterware manage crs resources?

1135


What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1153


What is dbcc? : sql server DBA

1345


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4476


Explain materialized views and how they are used.

2496


How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2083


when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1791