Interested to Buy Any Domain ? << Click Here >> for more details...
can we update a view which is created from two tables
- 11 Answers
- 33945 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
When is a declare statement required?
What are the limitations of sql express?
What does <> sql mean?
Why truncate is faster than delete?
define data blocks ? : Sql dba
What is dba in sql? : SQL DBA
Are sql database names case sensitive?
What is nested table in pl sql?
Explain the types of joins in sql?
What are its different types of dbms?
What steps server process has to take to execute an update statement?
How do you respond to dementia behavior?
How do I get sql certification?
What version is sql?
What is asqueryable?
