SQL Server2000数据库中触发器的妙用  

THE APPLICATION OF TRIGGER IN SQL SERVER2000

作　　者：程志梅[1] 邱霞明 王晓燕[1] 

机构地区：[1]东华理工大学数学与信息科学学院,江西抚州344000 [2]核工业270研究所遥感中心,江西南昌340000

出　　处：《计算机应用与软件》2009年第3期188-189,共2页Computer Applications and Software

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

关 键 词：触发器 表 记录 字段 完整性 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论] TN783[自动化与计算机技术—计算机科学与技术]