INSTEADOFUPDATE

例句

释义:
全部全部
类别:全部全部,口语口语,书面语书面语,标题标题,技术技术
来源:全部全部,字典字典,网络网络
难度:全部全部,简单简单,中等中等,难难
1.
A view with an INSTEAD OF UPDATE trigger cannot be a target of an UPDATE with a FROM clause.
带INSTEADOFUPDATE触发器的视图不能是含有FROM子句的UPDATE的目标。
msdn2.microsoft.com
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触发器。
msdn2.microsoft.com
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触发器必须不尝试更新基表中相应列的值。
msdn2.microsoft.com
4.
INSTEAD OF UPDATE triggers can be defined on a view or table to replace the standard action of the UPDATE statement.
可为视图定义INSTEADOFUPDATE触发器以代替UPDATE语句的标准操作。
msdn2.microsoft.com
5.
INSTEAD OF UPDATE triggers cannot be defined on a table that has a foreign key defined by using an UPDATE action.
对于含有用UPDATE操作定义的外键的表，不能定义INSTEADOFUPDATE触发器。
msdn2.microsoft.com
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触发器不必处理未更新的插入的列中的数据，因此该解决方法有效。
msdn2.microsoft.com
7.
INSTEAD OF UPDATE triggers should use values supplied for computed, identity, or timestamp columns only in WHERE clause search conditions.
INSTEADOFUPDATE触发器应使用仅在WHERE子句搜索条件中为计算列、标识列或timestamp列提供的值。
msdn2.microsoft.com
8.
INSTEAD OF UPDATE and DELETE triggers are not allowed on tables that are targets of cascaded referential integrity constraints.
不允许在作为级联引用完整性约束目标的表上使用INSTEADOFUPDATE和DELETE触发器。
msdn2.microsoft.com