Views (Level 2)
| SQL Server 6.x | SQL Server 2000 |
|---|---|
| Updatable views were restricted to modifications that affected only one table. | Updatable views can modify more than one table involved in the view. The DELETE, INSERT, and UPDATE statements can reference a view as long as SQL Server can translate the user's update request unambiguously to updates in the base tables referenced in the view's definition.
Expect differences in behavior when working with updatable views with more than one table involved in the DELETE, INSERT, or UPDATE statements. |