管理信息系统中SQL SERVER触发器之妙用

Clever Applications of SQL SERVER Trigger in MIS

分析了SQL SERVER数据库中触发器技术,以实际应用的管理信息系统为例,阐述了触发器的功能和具体应用.在实际的学生成绩管理系统中设置Update触发器、Insert触发器以及Delete触发器.起到了后台数据库必更新、插入、删除数据时,维护数据库的数据完整性的作用.实践证明,触发器是维护数据库数据完整性的有效方法.

Based on the analysis of the trigger technology of SQL SERVER and the management information system in use as an example, a detailed elaboration is made of the function and practical applications of the trigger. In students achievement management system, if the Update trigger, Insert trigger, and Delete trigger are set beforehand, the data integrity of the database can be well guaranteed when operations of ＂update, insert, delete data＂ are being done to the background database. Practice has proven that the use of a Trigger is an effective way to maintain data integrity.