视图修改准则（View modification criteria）.docVIP

视图修改准则（View modification criteria） If you do not use INSTEAD or OF trigger updatable partitioned views but through a view to modify the data before, then modify, please consider the following guidelines: If we in view definition using the WITH CHECK OPTION clause, all performed in view of the data modification statements must meet the requirements set in the SELECT statement that defines the view conditions. If the WITH CHECK OPTION clause is used, the need to pay attention to rows cannot make them disappear from view in after modification. Any changes may lead to lost will be canceled, and an error message. The SQL Server must be able to clearly resolve a particular line in the base table for reference to modify operation view. Not in a statement on a number of basic tables with data modification statements. Therefore, in the UPDATE column or columns in the INSERT statement must belong to the same base table in the view definition. The basis for the table to update and do not allow null values in all columns, the values specified in the INSERT statement or a DEFAULT definition. This will ensure that all of the required value of the underlying table column can obtain value. The revision based on the table of the data in the column of these columns must conform to the constraints, such as nullability, DEFAULT, constraint definition. For example, if you want to delete a line, then all FOREIGN KEY constraints in related tables must still be satisfied, delete to success. The distributed partitioned view (remote view) keyset driven cursor updates cannot be used. This limitation can be based on the table and not in the view itself declare myCursor resolved. In addition, if you delete the data in the view: You can only view definition in the FROM clause are listed in a table. Not in the view with text, ntext or image columns together with the READTEXT and WRITETEXT statements. Modifying data through a view You can modify the data base table through the view, the way and th