The informational constraints are not enforced by the federated server during operations such as insert, delete and update.
在诸如insert、delete和update操作期间,联邦服务器不施加信息约束。
Note that the delete operation fails if the record can't be deleted due to database-specific constraints.
DELETE employees WHEREemployeeid=@employeeid请注意,如果由于特定于数据库的约束而无法删除记录,删除操作将失败。
They can guard against malicious or incorrect INSERT, UPDATE and DELETE operations and enforce other restrictions that are more complex than those defined with CHECK constraints.
触发器可以预防恶意或错误的INSERT、UPDATE和DELETE操作,并强制执行比CHECK约束中定义的限制更复杂的限制。
应用推荐