SQL Server触发器在数据完整性和安全方面的应用

Application of SQL Server Trigger in Data Integrity and Security

探讨了SQL Server 2005数据库中触发器的概念、原理、类型、作用和创建,介绍了数据完整性概念、分类,重点给出了用SQL Server 2005触发器实现数据参照完整性和数据库安全性的应用。

The paper explores the SQL Server 2005 database trigger concept, principle, types, role and creation, and introduces the concept of data integrity, classification. Emphasis on the SQL Server 2005 trigger realizes the data referential integrity and database security application.