数据库触发器及简单应用

Database trigger and its simple application

随着数据库的应用越来越广泛,如何保证数据的完整性是数据库设计的重要内容之一。触发器是用户定义在关系表上的一类由事件驱动的特殊过程。当进行插入、删除、更新等操作时,触发器会自动执行,以便采取一些适当的措施,保证数据的完整性。文章以SQL Server2000数据库系统为例,讨论数据库触发器的创建及应用等问题。

With more and more extensive application of the database, how to ensure data integrity of the database design is one of the important contents. Trigger is a user-defined relation in the form of a class from the special event-driven process. When doing insert, delete, update and other operations, the implementation will automatically be triggered in order to take appropriate measures to ensure the integrity of the data. The article takes SQL Server2000 database system as an example to discuss the creation of the database and application of flip-flop, and other issues.