求个sql触发器
当表a的 aid行的a1列由1update为5时触发
update 表B where bid=aid

[解决办法]
判原值deleted 表
判修改之後的值inserted表

[解决办法]

SQL code

--大致如下,自行补充要更新表b的那个字段,及表b与表a的关联关系create tirgger tupdate_a on afor update asif update(a1) and exists(select 1 from inserted,deleted where inserted.aid = deleted.aid        and inserted.a1 = 1 and deleted.a1 = 5)begin    update 表B    set --自已补充    from  inserted,deleted    where inserted.aid = deleted.aid    and inserted.a1 = 1 and deleted.a1 = 5    and inserted.aid = 表B.bidend