The before trigger and check constraint on a table XML value always ensures that the XML values are valid as per the specified schema.
对一个表 XML 值应用 before trigger 和检查约束,往往可以确保 XML 值对于指定模式是有效的。
Similar to the before trigger, the IS VALIDATED ACCORDING TO XMLSCHEMA clause can be used in the check constraints to enforce the validation.
与 before trigger 类似,可以在检查约束中使用 IS VALIDATED ACCORDING TO XMLSCHEMA 子句来加强验证。
You'll notice that in this case (a before trigger invoked by an update), you can only specify that the trigger fire on each row, not each statement.
您将注意到,在这种情况下(一个在UPDATE之前被激活的触发器),您只能指定触发器针对每行而不是针对每个语句触发。
应用推荐