创建视图的语句是设置了 WITH CHECK OPTION 这个条件; 创建视图时,sql语句是这样写的: CREATE OR REPLACE VIEW RZ_TST_VIEW AS WHERE SELECT * FROM RZ_TST WHERE CARDID=12345 OR CARDID=12347 WITH CHECK OPTION; 创建成功之后如图所示: 这个时候再进行插入操作的时候,报了如上图的错误,SQL语句如下: INSERT...
WithCheckOption property class of View 命名空间: Microsoft.SqlServer.Dac.Model 程序集: Microsoft.SqlServer.Dac.Extensions(在 Microsoft.SqlServer.Dac.Extensions.dll 中) 语法 C# 复制 public static ModelPropertyClass WithCheckOption { get; internal set; } 属性值 类型:Microsoft.SqlServer.Dac.Model.Mo...
publicstaticMicrosoft.SqlServer.Dac.Model.ModelPropertyClass WithCheckOption {get; } Property Value ModelPropertyClass Applies to ProductVersions Microsoft.SQLServer.DacFx140.3881.1, 150.18208.0, 160.2004021.0, 161.6374.0, 162.2.111 In this article ...
WITH CHECK OPTION is an optional clause on the CREATE VIEW statement. It specifies the level of checking when data is inserted or updated through a view.
With no check option, the viewWHEREclause is not checked, then checking recurses to underlying views, and applies the same rules. Consider the definitions for the following table and set of views: CREATETABLEt1(aINT);CREATEVIEWv1ASSELECT*FROMt1WHEREa<2WITHCHECKOPTION;CREATEVIEWv2ASSELECT*FROMv...
With no check option, the viewWHEREclause is not checked, then checking recurses to underlying views, and applies the same rules. Consider the definitions for the following table and set of views: CREATETABLEt1(aINT);CREATEVIEWv1ASSELECT*FROMt1WHEREa<2WITHCHECKOPTION;CREATEVIEWv2ASSELECT*FROMv...
With no check option, the viewWHEREclause is not checked, then checking recurses to underlying views, and applies the same rules. Consider the definitions for the following table and set of views: CREATE TABLE t1 (a INT); CREATE VIEW v1 AS SELECT * FROM t1 WHERE a < 2 ...
WITH CHECK OPTION is an optional clause on the CREATE VIEW statement. It specifies the level of checking when data is inserted or updated through a view.
获取或设置一个对 WITH CHECK OPTION 选项建模的值。 命名空间:Microsoft.Data.Schema.Sql.SchemaModel 程序集:Microsoft.Data.Schema.Sql(在 Microsoft.Data.Schema.Sql.dll 中) 语法 C# boolIsWithCheckOption {get;set; } 属性值 类型:System.Boolean ...
要求对该视图执行的所有数据修改语句都必须符合 select_statement 中所设置的条件。 通过视图修改行时,WITH CHECK OPTION 可确保提交修改后,仍可通过视图看到数据。备注 CHECK OPTION 仅适用于通过视图进行的更新。 它不适用于直接对视图的基础表执行的任何更新。