can we update a view which is created from two tables
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
Define implicit and explicit cursors.
How can you load multi line records? : aql loader
how many groups of data types? : Sql dba
What is pl sql quora?
What is the difference between truncate and drop statements?
What is the use of procedures?
Does execute immediate commit?
What is dba in sql? : SQL DBA
Why do we use %rowtype & %type in plsql?
What is the difference between jpql and sql?
What is restrict in sql?
How to handle bulk data?
what are all types of user defined functions? : Sql dba
Can two tables have same primary key?
What's the procedure?