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约束中定义的限制更复杂的限制。
You can use table Designer to create, edit, or delete tables, columns, keys, indexes, relationships, and constraints.
可以使用表设计器创建、编辑或删除表、列、键、索引、关系和约束。
What is the most efficient way of doing this short of trying to delete each one at a time and letting it cause SQL errors on the ones that violate constraints?
什么是最有效的方法做到这一点,试图一次删除每一个,让它导致SQL错误违反约束的错误?
What is the most efficient way of doing this short of trying to delete each one at a time and letting it cause SQL errors on the ones that violate constraints?
什么是最有效的方法做到这一点,试图一次删除每一个,让它导致SQL错误违反约束的错误?
应用推荐