大家在查： backflow 十分出色颗任性四、五布兰迪 1740年 Tsutsui ODBC 立业 retrievals

INSTEADOFUPDATE

INSTEADOFUPDATE

INSTEADOFUPDATE

INSTEADOFUPDATE

1

A view with an INSTEAD OF UPDATE trigger cannot be a target of an UPDATE with a FROM clause .

带 INSTEADOFUPDATE 触发器的视图不能是含有 FROM 子句的 UPDATE 的目标。

2

INSTEAD OF DELETE and INSTEAD OF UPDATE triggers cannot be defined on a table that has a foreign key defined with a DELETE or UPDATE action .

对于含有用 DELETE 或 UPDATE 操作定义的外键的表，不能定义 INSTEADOFDELETE 和 INSTEADOFUPDATE 触发器。

3

To do this , the INSTEAD OF UPDATE trigger must not try to update the values for the corresponding columns in the base table .

要做到这一点，INSTEADOFUPDATE 触发器必须不尝试更新基表中相应列的值。

4

INSTEAD OF UPDATE triggers can be defined on a view or table to replace the standard action of the UPDATE statement .

可为视图定义 INSTEADOFUPDATE 触发器以代替 UPDATE 语句的标准操作。

5

INSTEAD OF UPDATE triggers cannot be defined on a table that has a foreign key defined by using an UPDATE action .

对于含有用 UPDATE 操作定义的外键的表，不能定义 INSTEADOFUPDATE 触发器。

6

This solution works because an INSTEAD OF UPDATE trigger does not have to process data from the inserted columns that are not updated .

由于 INSTEADOFUPDATE 触发器不必处理未更新的插入的列中的数据，因此该解决方法有效。

8

INSTEAD OF UPDATE and DELETE triggers are not allowed on tables that are targets of cascaded referential integrity constraints .

不允许在作为级联引用完整性约束目标的表上使用 INSTEADOFUPDATE 和 DELETE 触发器。

9

Typically , the INSTEAD OF UPDATE trigger is defined on a view to modify data in one or more base tables .

通常，在视图上定义 INSTEADOFUPDATE 触发器来修改一个或多个基表中的数据。

热词推荐

大家在看