Interested to Buy Any Domain ? << Click Here >> for more details...
can we update a view which is created from two tables
- 11 Answers
- 34087 Views
- I also Faced
- E-Mail Answers
Answer Posted / sankar
It is not possible to update a view which is created from
two tables.Actually when we update any viewtha first the
view has been updated followed by the base table.If we use
instead of trigger then the base be table will updated
first not the view.Because the view is stored in database
as a query.Once the base table will be changed,the view
query will hit the base table and reflects the changes.But
I think that's not the desired answer.
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
How would you pass hints to the sql processor?
how to convert character strings to dates? : Sql dba
What is localdb mssqllocaldb?
What version is sql?
How to display the current date in sql?
What is the purpose of a secondary key?
what is the difference between join and union? : Sql dba
What is a null value?
What is a trigger word?
What is lookup table in sql?
what is the difference between a local and a global temporary table? : Sql dba
What does where 1/2 mean in sql?
What is a unique key?
What is composite data type in pl sql?
What is the maximum database size for sql express?
