| 管理信息系统中SQL SERVER触发器之妙用简 |
| |
| 引用本文： | 庄彦.管理信息系统中SQL SERVER触发器之妙用简[J].内江师范学院学报,2014(2):22-24. |
| |
| 作者姓名： | 庄彦 |
| |
| 作者单位： | 安徽工商职业学院电子信息系,安徽合肥230041 |
| |
| 基金项目： | 安徽工商职业学院质量工程课改项目（2010ykg03） |
| |
| 摘 要： | 分析了SQL SERVER数据库中触发器技术,以实际应用的管理信息系统为例,阐述了触发器的功能和具体应用.在实际的学生成绩管理系统中设置Update触发器、Insert触发器以及Delete触发器.起到了后台数据库必更新、插入、删除数据时,维护数据库的数据完整性的作用.实践证明,触发器是维护数据库数据完整性的有效方法.
|
| 关 键 词： | 触发器 数据完整性 管理信息系统 |
Clever Applications of SQL SERVER Trigger in MIS |
| |
| ZHUANG Yan.Clever Applications of SQL SERVER Trigger in MIS[J].Journal of Neijiang Teachers College,2014(2):22-24. |
| |
| Authors: | ZHUANG Yan |
| |
| Institution: | ZHUANG Yan (Electron Information Department, Anhui Vocational College of Commerce and Industry, Hefei, Anhui 230041, China) |
| |
| Abstract: | 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. |
| |
| Keywords: | trigger data integrity MIS |
| 本文献已被 CNKI 维普 等数据库收录！ |
|
