SQL Server触发器在数据库系统开发中的应用研究  

Research on the application of SQL Server trigger in the development of database system

作　　者：吴锋珍[1] WU Feng-zhen(Fujian College of Water Conservancy and Electric Power,Yong＇an,Fujian,China 3660)

机构地区：[1]福建水利电力职业技术学院,福建永安366000

出　　处：《湖南邮电职业技术学院学报》2018年第2期39-42,共4页Journal of Hunan Post and Telecommunication College

摘　　要：触发器是数据库设计的灵魂,灵活使用触发器,可以为数据库系统开发带来更多的方便。文章首先简单介绍触发器的基本知识,然后从数据完整性约束、架构安全性和登录审计三个方面详细分析触发器的应用。测试结果表明,应用效果良好。Trigger is the soul of database design, and the flexible use of trigger can bring more convenience for the development of database system. In this paper, the basic knowledge of trigger is introduced briefly, and then the application of trigger is analyzed in three aspects： data integrity constraints, architecture security and login audit. The test results show that the application effect is good.

关 键 词：数据库 触发器 DML DDL 登录 

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