Views (Level 2)

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.

Expect differences in behavior when working with updatable, partitioned views that have more than one table involved in  DELETE, INSERT, or UPDATE statements.


Show: