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
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What is dcl? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What purpose does the model database server? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
how can you schedule a job in database?
what is logical system in sap basis
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
how can you enable flashback feature?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is the default fill factor value? : sql server DBA
internal architecture
How do you troubleshoot errors in a sql server agent job? : sql server DBA