In the SQL Server database to form the integrity constraints on the database to implement complex, the trigger is ide⁃al selection tool. It can be cascaded to modify the database table, the maintenance of data consistency. It is implemented by the event to trigger, when on a table to insert, update, delete operations will activate it execution, thus through the execution of trig⁃gers to better achieve the integrity constraints andbusiness rules, data etc..%在SQL Server数据库中为了对数据库表实施复杂的完整性约束,触发器是比较理想的选择工具。它可以对数据库表进行级联修改,保持数据的一致性。它的执行是由事件来触发,当对一个表进行插入、更新、删除操作时就会激活它执行,从而通过触发器的执行更好地实现数据的完整性约束和业务规则等。
展开▼