【摘要】 触发器是一种特殊的存储过程,它不能被显式地调用,而是在往表中插入、更改或者删除记录时,被自动地激活。全面阐述了SQL Server2000的触发器技术,通过具体实例说明了INSTEADOF触发器及AFTER触发器的应用,完成了比默认值及公式都更为复杂的字段值的设置,显示了触发器在维护数据表之间一致性、保持数据的相关完整性方面所具有的强大功能。更多还原

【Abstract】 Trigger is a special stored procedure,which can’t be called explicitly but be activated automatically when the tables were inserted,updated or deleted the records.This article discussed the trigger’s technique in SQL Server 2000,gave two detailed examples,trigger INSTEAD OF and trigger AFTER,to explain the trigger’s application,finished more complex value setting of fields than default and formula.It shows the trigger’s strong ability in maintaining consistency among data tables and in keeping data integrality.更多还原