>>View: Well, a view simply isn't identical to a table, client or not, and if you try to insert something into a view the error that will pop up will clearly explain the difference.<<
>>INSTEAD OF triggers are there to support view updatability.<<
Assuming Permitions are granted, some views can be updatable even without instead of triggers :
a view does not use an INSTEAD OF trigger or is not an updatable partitioned view, it can still be updatable provided that:
- The view contains at least one table in the FROM clause of the view definition; the view cannot be based solely on an expression.
- No aggregate functions (AVG, COUNT, SUM, MIN, MAX, GROUPING, STDEV, STDEVP, VAR, VARP) or GROUP BY, UNION, DISTINCT, or TOP clauses are used in the select list. However, aggregate functions can be used within a subquery defined in the FROM clause provided that the derived values generated by the aggregate functions are not modified.
- No derived columns are used in the select list. Derived columns are result set columns formed by anything other than a simple column reference
[edit:] And I should add that the update statement should affect columns on a single base table