SQL Server触发器在保持数据库完整性中的应用

Application of SQL Server Trigger in Maintaining the Integrity of Database

触发器在保持数据库的完整性与一致性方面起着非常重要的作用,它是一种保证数据库中数据完整性的方法。讲述了DML触发器的类型、工作机理及触发机制。以BBS论坛数据库为例,介绍了触发器在保持数据库完整性中的具体应用。

The trigger plays a vital role in maintaining the integrity and consistency of database, and is one kind of methods which guarantee the data integrity of database. This paper presents the DML trigger work mechanism and types and how the triggers work. Taking the BBS forum database as an example this paper introduces the application of trigger in maintaining the integrity of database.