34,838
社区成员




create trigger TXL_Unit_Update
on StrongMain_NH.dbo.L05_Unit
after update
as
begin
update PDA_NH.dbo.[TXL_Unit]
set u.[Unit]=i.[Unit],[Sort]=i.DisplayNo
from inserted i,deleted d left join PDA_NH.dbo.[TXL_Unit] u
on u.[UnitID] = d.[UnitID]
end
create trigger TXL_Unit_Update
on StrongMain_NH.dbo.L05_Unit
after update
as
begin
update PDA_NH.dbo.[TXL_Unit]
set u.[Unit]=i.[UnitName],[Sort]=i.DisplayNo
from inserted i,deleted d left join PDA_NH.dbo.[TXL_Unit] u
on u.[UnitID] = d.[UnitID]
end