create TRIGGER [dbo].[tr_inser_SAMPLEAPPR]
ON [dbo].[SAMPLEAPPR]
AFTER UPDATE
NOT FOR REPLICATION
AS IF NOT UPDATE(temp_product_code)
RETURN
ELSE
BEGIN update sid set
product_code=i.product_code
from sid,inserted i
where sid.so_number=i.so_number
and sid.order_number=i.order_number
update dncsd set
product_code=i.product_code
from dncsd,inserted i
where dncsd.so_number=i.so_number
and dncsd.order_number=i.order_number END
GO
ON [dbo].[SAMPLEAPPR]
AFTER UPDATE
NOT FOR REPLICATION
AS IF NOT UPDATE(temp_product_code)
RETURN
ELSE
BEGIN update sid set
product_code=i.product_code
from sid,inserted i
where sid.so_number=i.so_number
and sid.order_number=i.order_number
update dncsd set
product_code=i.product_code
from dncsd,inserted i
where dncsd.so_number=i.so_number
and dncsd.order_number=i.order_number END
GO
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货