lw 18:24:29这是mysql的创建语句CREATE TRIGGER <触发器名称>{ BEFORE | AFTER } { INSERT | UPDATE | DELETE } ON <表名称>FOR EACH ROW <触发器SQL语句>这是SqlServer的：CREATE TRIGGER <触发器名称>展开
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的一个实例 收起
