摘要
对数据进行频繁的更新操作可能破坏数据库的完整性,合理设计触发器可以有效保护数据。本文讨论在SQL Serv-er 2005中通过DML触发器技术实现数据的完整性控制机制,重点论述DML触发器工作原理和实现过程,并结合实例分析设计触发器的基本步骤。测试结果表明,触发器的应用可提高系统性能,很好地维护数据库的完整性。
Frequently updating data may undermine the integrity of database, and trigger properly designed can protect data effec- tively. The paper discusses the basic steps of data integrity control mechanism according to DML trigger technology in SQL Server 2005. It focuses on DML trigger work principle and implementation process with examples of triggers design. The test results show that the application of trigger improves the system performance and maintains the integrity of database.
出处
《计算机与现代化》
2013年第4期57-59,共3页
Computer and Modernization
基金
河南省教育厅自然科学研究计划项目(201210919013)
