|
Posted by --CELKO-- on 10/18/05 23:17
In Standard SQL, an updatable view has to be built on one table and has
to include a key. The idea is that a row in the VIEW maps to one and
only one row in the base table. It is very restricted.
Some vendors allow for more power than that, but this is not uniform or
well-defined. The real problem is that the question of view updatablity
is known to be undecidable.
What you have as a portable, standard way to handle a multi-table view
update is an INSTEAD OF trigger. You can look up the SQL Server
version in BOL.
Navigation:
[Reply to this message]
|