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 |
What is sub query and its properties?
What is the difference between insensitive and scroll cursor?
what is a join? : Sql server database administration
What is table constraint?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
How to drop existing indexes in ms sql server?
What does the update command do?
how we can count records as a group of days like sum of records for(four mondays),(four tuesday)........ in a month. group the column for weekdays.
What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)
Explain the cursor lock types?
How to restore performance issues and how to check?
Can group by be used without aggregate functions?
Oracle (3253)
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)