lw 18:24:29这是mysql的创建语句CREATE TRIGGER <触发器名称> { BEFORE | AFTER } { INSERT | UPDATE | DELETE } ON <表名称> FOR EACH ROW <触发器SQL语句> 这是SqlServer的：CREATE TRIGGER <触发器名称> ON <表名称> { for | AFTER|instead of } { INSERT | UPDATE | DELETE } FOR EACH ROW <触发器SQL语句> wlw 18:25:54这是SqlServer的：CREATE TRIGGER <触发器名称> ON <表名称> { for | AFTER|instead of } { INSERT | UPDATE | DELETE } <触发器SQL语句> wlw 18:30:36create trigger contract_log_triggeron contractafter updateasbeginif ((select audit from inserted) > 0) 需要执行的sql语句end这是SqlServer的一个实例