| 触发器在保持数据库完整性方面的应用 |
| |
| 引用本文： | 怀艾芹.触发器在保持数据库完整性方面的应用[J].天津职业院校联合学报,2011,13(2):92-95. |
| |
| 作者姓名： | 怀艾芹 |
| |
| 作者单位： | 天津机电职业技术学院,天津市,300131 |
| |
| 摘 要： | 触发器是SQL Server数据库管理系统为应用程序开发人员提供的一种保证数据库中数据完整性的方法,是一种特殊类型的存储过程。在对触发器的概念,作用,类型进行阐述的基础上,说明使用SQL Server2005 DML触发器可以保证实现check约束、foreign key约束等组件无法实现的复杂的数据完整性。
|
| 关 键 词： | 数据库 数据完整性 触发器 SQL Server 2005 |
The Role that Trigger Plays in Maintaining the Integrity of Data-base |
| |
| HUAI Ai-qin.The Role that Trigger Plays in Maintaining the Integrity of Data-base[J].Journal of Tianjin Vocational Institutes,2011,13(2):92-95. |
| |
| Authors: | HUAI Ai-qin |
| |
| Institution: | HUAI Ai-qin(Tianjin Vocational College of Mechanics and Electricity,Tianjin 300131 China) |
| |
| Abstract: | Trigger is a method that guarantees the integrity of data-base and a special type of stored procedure.It is provided by SQL Server data-base management system to developers of application programs.After an elaboration of the trigger's concept,functions and types,the paper declares that the SQL Server 2005 DML trigger can guarantee the complicated data integrity. |
| |
| Keywords: | data-base data integrity trigger SQL Server 2005 |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
