如何实现这样的触发器?

[迭戈爱足球]

当b.expiredby<getdate()条件成立时,要进行update merchant_info.这个需要在网站的运行中自动更新.如何写.谢谢

以下是sql语句
update merchant_info

set discount=BookDiscount,
promotionTag=-1,
pDiscountType=BdiscountType

where merchantID in

( select distinct b.merchantID from broadcast_info b where b.expiredby<getdate() )

[迭戈爱足球]

和大家分享一下我写的.不知道如何.大家说说.我是楼主:



CREATE TRIGGER myTrigger
ON broadcast_info
FOR UPDATE
AS
update merchant_info

set discount=BookDiscount,
promotionTag=-1,
pDiscountType=BdiscountType

from broadcast_info
where merchant_info.merchantID in
( select distinct broadcast_info.merchantID from broadcast_info where broadcast_info.expiredby < getdate() )


GO

[冷箫轻笛]

update merchant_info

set discount=BookDiscount,
promotionTag=-1,
pDiscountType=BdiscountType

where merchantID in

( select distinct b.merchantID from inserted b where b.expiredby<getdate() )

[txlicenhe]

当b.expiredby<getdate()条件成立时
------------------------------------
这个条件好象只能用调度，而没办法用触发器。