Views (Level 2)
New Information - SQL Server 2000 SP3.
|SQL Server 6.x||SQL Server 2000|
|Updatable views were restricted to modifications that affected only one table.||Partitioned 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.|