Interested to Buy Any Domain ? << Click Here >> for more details...
can we update a view which is created from two tables
- 11 Answers
- 34070 Views
- I also Faced
- E-Mail Answers
Answer Posted / duong
Views in all versions of SQL Server are updatable (can be the target of UPDATE, DELETE, or INSERT statements), as long as the modification affects only one of the base tables referenced by the view, for example:
-- Increase the prices for publisher '0736' by 10%.
UPDATE titleview
SET price = price * 1.10
WHERE pub_id = '0736'
GO
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you use a while loop in pl sql?
What is a schema? How is it useful in sql servers?
Are views faster than queries?
How do I pipe the output of one isql to another?
How is data stored in sql?
What do you understand by pl/sql records?
What are different methods to trace the pl/sql code?
What is set transaction?
Differentiate between sga and pga.
What are the different types of functions in sql?
What is the purpose of the primary key?
What is sql keyword?
Are there any features that are decommissioned in 11g that are not present in 11g?
What is pl sql package?
How do I turn a list into a table?
