浅析SQL Server2005中的DDL触发器技术

Analyzing DDL Triggers Techniques in SQL Server2005

SQL Server2005扩展了触发器的功能,从数据操纵语言又增加了数据定义语言,这项新技术叫DDL触发器。分析了DDL触发器的基本功能、工作原理及用法,举例说明了DDL的两种基本应用。

SQL Server2005 has extended the trigger function,adding Data Definition Language（DDL）in Data Manipulation Language（DML）,which is called DDL triggers.The thesis analyzes the basic function,working theory and using method of DDL triggers and introduces two kinds of application to readers.