Interested to Buy Any Domain ? << Click Here >> for more details...
can we update a view which is created from two tables
- 11 Answers
- 34387 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
Enlist the characteristics of pl/sql?
What is group by in sql?
explain mysql aggregate functions. : Sql dba
What does stand for in sql?
What do you understand by pl/sql cursors?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
Can dml statements be used in pl/sql?
Why self join is used in sql?
explain what is mysql? : Sql dba
Can you have a foreign key without a primary key?
what is the difference between delete and truncate commands? : Sql dba
Is mariadb a nosql database?
How do I find duplicates in a single column in sql?
define join and explain different type of joins? : Sql dba
Can ddl statements be used in pl/sql?
