CREATE TRIGGER zfxt_update_bom ON [CQAdmin].[dcn]
FOR UPDATE
AS
begin
update bom
set part=ccc.part
from inserted ccc
where bom.partnumber=ccc.partnumber
end
FOR UPDATE
AS
begin
update bom
set part=ccc.part
from inserted ccc
where bom.partnumber=ccc.partnumber
end
FOR UPDATE
AS
begin
update bom a
set a.part=ccc.part
from inserted ccc
where a.partnumber=ccc.partnumber
end