| 触发器在数据库中的应用 |
| |
| 引用本文： | 刘晓平.触发器在数据库中的应用[J].韶关学院学报,2007,28(3):35-38. |
| |
| 作者姓名： | 刘晓平 |
| |
| 作者单位： | 韶关学院,计算机系,广东,韶关,512005 |
| |
| 摘 要： | 触发器是SQL Server为应用程序开发人员提供的一种保证数据库中数据完整性的方法，它是一种特殊的存储过程．简述了触发器的概念、工作原理及类型，分析了与触发器相关的两个逻辑表，并给出了SQL Server触发器应用实例．实践表明，触发器是实现数据维护规则的有效机制
|
| 关 键 词： | SQL Server After触发器 Instead of触发器 数据完整性 |
| 文章编号： | 1007-5348（2007）03-0035-04 |
| 修稿时间： | 2006-11-27 |
The application of trigger in database |
| |
| LIU Xiao-ping.The application of trigger in database[J].Journal of Shaoguan University(Social Science Edition),2007,28(3):35-38. |
| |
| Authors: | LIU Xiao-ping |
| |
| Institution: | Department of Computer, Shaoguan University, Shaoguan 512005, Guangdong, China |
| |
| Abstract: | Trigger is a kind of method that SQL Server provides for application developer to assurance database in the data integrity, it is a kind of special stored procedure. The paper introduces the principle and concept, types of the triggers. It presents the two related logicautomaticaUy data updating and backup, and it provides the examples for application. Experimental resuhs show that it is available and effective to implement some automatic rules of data maintenance by utilizing trigger mechanism. |
| |
| Keywords: | SQL Server |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
