--sorry--
create trigger a on 订单明细表 after insert as
update 订单主表 set Amount=Amount+Amt,TotalPrice=TotalPrice+Amt*UnitPrice
from inserted where inserted.orderNo=订单主表.orderNo
create trigger a on 订单明细表 after insert as
update 订单主表 set Amount=Amount+Amt,TotalPrice=TotalPrice+Amt*UnitPrice
from inserted where 订单明细表.orderNo=订单主表.orderNo