UPDATE statement can on a single table or on the multiple
table?
Answers were Sorted based on User's Feedback
Answer / govind
yes. But by using views(some) we r able to update the
multiple table
| Is This Answer Correct ? | 17 Yes | 4 No |
Answer / sandeep
single table.
View is updatable if it is a only one table reference view.
| Is This Answer Correct ? | 3 Yes | 1 No |
Can you insert NULL in unique column?
What is executereader?
What are the essential components of sql server service broker?
What is difference between rownum and row_number?
can you any body tell me the how to decrease the logfile
What is the difference between Clustered and Non-Clustered Index?
what is web server?
What is meant by dirty read?
Explain sql server authentication modes?
system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??
What is implicit cursors?
What is merge statement?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)