CREATE TRIGGER TestTRIGGER ON URC_ORDER_LINE for UPDATE AS BEGIN SET NOCOUNT ON; if update(UNITPRICE) update PART set UNIT_MATERIAL_COST = b.UNITPRICE from PART a,deleted b where a.PART_ID = b.ID END GO
22,302
社区成员
121,734
社区内容
加载中
试试用AI创作助手写篇文章吧