计算机技术与发展2012，Vol.22Issue(6)：229-233,5.
基于SQL Server2008的DML触发器设计实例分析
Analysis of DML Triggers Design Example Based on SQL Server 2008
摘要
Abstract
SQL Server database is a representative large- scale network database of the information management system. It discusses, in SQL Server 2008, trigger technology to realize data integrity mechanism, introduces the concept, classification of the trigger, mainly dials with the DML trigger implementation process,combined with specific examples,the design DML triggers supervision of finance staff a variety of business operations including insert, delete and update records. Analyse the trigger design of the basic steps and optimize the design ,lo use the audit-table records all the change data. It reflects the trigger application in improving system performance,maintaining database integrity, validity of the powerful function.关键词
数据库/完整性/DML触发器/SQL ServerKey words
database/integrity/DML triggers/SQL Server分类
信息技术与安全科学引用本文复制引用
綦宝声..基于SQL Server2008的DML触发器设计实例分析[J].计算机技术与发展,2012,22(6):229-233,5.基金项目
国家自然科学基金项目(61070202) （61070202）
山东省高等学校优秀青年教师国内访问学者项目 （）
