Interested to Buy Any Domain ? << Click Here >> for more details...
can we update a view which is created from two tables
- 11 Answers
- 34039 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
what is the different between now() and current_date()? : Sql dba
how to create a new table in mysql? : Sql dba
How do I remove duplicates in two columns?
How exception handling is done in advance pl/sql?
State some properties of relational databases?
How do you take the union of two tables in sql?
what is the difference between nested subquery and correlated subquery?
What jobs use sql?
What is sql partition?
What is a data manipulation language?
What is sql select statement?
what is log shipping? : Sql dba
Can variables be used in sql statements?
What is mdb stand for?
Why we use sql profiler?
