Interested to Buy Any Domain ? << Click Here >> for more details...
can we update a view which is created from two tables
- 11 Answers
- 33581 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 autocommit sql?
What is identity column in sql server?
How many types of indexes are there in sql?
Why triggers are used?
What is interval partition?
What is the function that is used to transfer a pl/sql table log to a database table?
Can you call pl/sql package functions from within a fast formula?
What is fmtonly in sql?
Is there any restriction on the use of union in embedded sql?
What is sorting in sql?
what is the difference between myisam static and myisam dynamic? : Sql dba
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
how to enter numeric values as hex numbers? : Sql dba
what is foreign key? : Sql dba
What is varchar used for?
