/*1 tg_in*/
after insert
update e set eage=case when e.ed='xx' then 'xx' else 'xx' end
from e,i
where e.id=i.id
/*2 tg_up*/
after update
if update(ed)
update e set eage=case when e.ed='xx' then 'xx' else 'xx' end
from e,inserted i
where e.id=i.id
追问我用的软件是sql2012,能给下这个代码吗,谢谢
本回答被网友采纳