9.1.1DML触发器创建 使用 CREATE TRIGGER命令创建DML触发器的语法形式如 CREATE TRIGGER [schema name. ]trigger_name oN tablel] WITH IENCRYPTION EXECUTE AS Clausell.nJ] IFORAFTERIINSTEAD OF]t[INSERTI L] [UPDATEI L] [DELETEJ] IWITH APPENDI INOT FOR REPLICATION AS sql statement [ ][.nIEXTERNAL NAME <method specifier []y < method specifier>∷= assembly_ name class name. method-name SQL SERVER2005入门与实例教程电子工业出版社20069.1.1 DML触发器创建 •使用CREATE TRIGGER命令创建DML触发器的语法形式如 下： CREATE TRIGGER [schema_name.]trigger_name ON {table|view} [WITH [ENCRYPTION] EXECUTE AS Clause][,...n]] {FOR|AFTER|INSTEAD OF} {[INSERT] [,] [UPDATE] [,] [DELETE]} [WITH APPEND] [NOT FOR REPLICATION] AS {sql_statement [;] [...n]|EXTERNAL NAME <method specifier [;]>} <method_specifier> ::= assembly_name.class_name.method_name