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.
• UPDATE
statements cannot modify PRIMARY KEY
columns if the member tables have text
, ntext
, or image
columns.
• Inserts and updates to a partitioned view are not allowed if the view contains a time stamp.
• Identity columns in a partitioned view cannot be modified by an INSERT
or UPDATE
statement. ...
Get Microsoft® SQL Server 2008 R2 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.