Modifying Data Through a Partitioned View
You can modify data via a partitioned view if the SQL statement performing the modification meets certain conditions, as described here:
All columns in the partitioned view must be specified in the INSERT statement. Columns that include a DEFAULT constraint or allow nulls are also subject to this requirement.
The DEFAULT keyword cannot be used on inserts to partitioned views or on updates to partitioned views.
Inserts and updates to a partitioned view are not allowed if the view contains a time stamp. ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
