忘電子工堂出版 8.2.2利用 CREATE TRIGGER命令创建触发器 CREATE TRIGGER的语法规则如下 CREATE TRIGGER trigger_name on i table view] I WITH ENCRYPTION lalt i FoR I AFTER I INSTEAD OF][[ DELETE][ NSERT]L][ UPDATE] I NOT FOR REPLICATION I AS d IF UPDATE(column)[i AND OR UPDATE (column) n (COLUMNS_UPDATED ) bitwise_operator Updated_bitmask d comparison_operator]column_ bitmask[.n ] sql_ statement[…n] 返回目录• 8.2.2 利用 CREATE TRIGGER 命令创建触发器 • CREATE TRIGGER的语法规则如下 • CREATE TRIGGER trigger_name ON { table | view } • [ WITH ENCRYPTION ] • {{ { FOR | AFTER | INSTEAD OF } { [ DELETE ] [ , ] [ INSERT ] [ , ] [ UPDATE ] } • [ NOT FOR REPLICATION ] • AS • [ { IF UPDATE (column) [ { AND | OR } UPDATE (column) ] • [ ...n ] • | IF (COLUMNS_UPDATED () {bitwise_operator }updated_bitmask) • { comparison_operator } column_bitmask [ ...n ] • }] • sql_statement [ ...n ] • }} 返回目录