insert into Client2Other (ClientID,ClientSimName,Addr,Distance) select ClientID,ClientSimName,Addr,Distance from inserted，把这个触发器，改成，不存在就插入，存在就更新，主键是ClientID,Addr

好的，你可以将触发器改为以下代码：

CREATE TRIGGER trg_Client2Other
ON Client2Other
AFTER INSERT
AS
BEGIN
    SET NOCOUNT ON;

    MERGE Client2Other AS target
    USING inserted AS source
    ON (target.ClientID = source.ClientID AND target.Addr = source.Addr)
    WHEN MATCHED THEN
        UPDATE SET ClientSimName = source.ClientSimName, Distance = source.Distance
    WHEN NOT MATCHED THEN
        INSERT (ClientID, ClientSimName, Addr, Distance)
        VALUES (source.ClientID, source.ClientSimName, source.Addr, source.Distance);
END

这个触发器使用了 MERGE 命令，当目标表中存在与源表匹配的主键时，更新目标表中的记录。如果主键不存在，则在目标表中插入新记录。这样就实现了不存在就插入，存在就更新的功能，同时避免了主键重复的问题。

相关问题

insert into Client2Other (ClientID, ClientSimName, Addr, Distance) select ClientID, ClientSimName, Addr, Distance from #t，改成存在更新，不存在插入，主键是ClientID，Addr

可以使用 MERGE 语句实现存在更新，不存在插入的操作，示例代码如下：

MERGE INTO Client2Other AS c
USING #t AS t
ON c.ClientID = t.ClientID AND c.Addr = t.Addr
WHEN MATCHED THEN
    UPDATE SET c.ClientSimName = t.ClientSimName, c.Distance = t.Distance
WHEN NOT MATCHED THEN
    INSERT (ClientID, ClientSimName, Addr, Distance)
    VALUES (t.ClientID, t.ClientSimName, t.Addr, t.Distance);

这里使用了 MERGE 语句，将 `Client2Other` 表作为目标表，`#t` 表作为源表。`ON` 子句中指定了匹配条件，即 `ClientID` 和 `Addr` 都相等时为匹配。`WHEN MATCHED` 子句表示当匹配时执行更新操作，将源表中的数据更新到目标表中；`WHEN NOT MATCHED` 子句表示当不匹配时执行插入操作，将源表中的数据插入到目标表中。同时，我们指定了主键为 `ClientID` 和 `Addr`，这样可以保证数据的唯一性。

insert into Q_SaleOrder2Other (OrderID,OrderQTY,ArrangeSmallQTY,ProQTY,QlyInQTY, DelArrQTY,DelQTY,CancelOrderQTY,OperateTime,MakeBillDate, DeliveryAddr,DeliveryDate,ClientID,UnitCub) select top 1000 OrderID,OrderQTY,ArrangeSmallQTY,ProQTY,QlyInQTY, DelArrQTY,DelQTY,CancelOrderQTY,getdate(),MakeBillDate, DeliveryAddr,DeliveryDate,ClientID,UnitCub from Q_SaleOrder where OrderQTY-DelQTY>CancelOrderQTY order by MakeBillDate desc,OrderID desc，把这个改成，存在就插入否则跳过，主键是OrderID

你的问题是如何将SQL语句改为存在即插入的语句，并且主键为OrderID。可以使用MERGE语句实现这个需求，具体语法如下：

MERGE INTO Q_SaleOrder2Other AS target
USING (SELECT TOP 1000 OrderID, OrderQTY, ArrangeSmallQTY, ProQTY, QlyInQTY, DelArrQTY, DelQTY, CancelOrderQTY, getdate() AS OperateTime, MakeBillDate, DeliveryAddr, DeliveryDate, ClientID, UnitCub
       FROM Q_SaleOrder 
       WHERE OrderQTY - DelQTY > CancelOrderQTY 
       ORDER BY MakeBillDate DESC, OrderID DESC) AS source
ON (target.OrderID = source.OrderID)
WHEN NOT MATCHED BY TARGET THEN
    INSERT (OrderID, OrderQTY, ArrangeSmallQTY, ProQTY, QlyInQTY, DelArrQTY, DelQTY, CancelOrderQTY, OperateTime, MakeBillDate, DeliveryAddr, DeliveryDate, ClientID, UnitCub)
    VALUES (source.OrderID, source.OrderQTY, source.ArrangeSmallQTY, source.ProQTY, source.QlyInQTY, source.DelArrQTY, source.DelQTY, source.CancelOrderQTY, source.OperateTime, source.MakeBillDate, source.DeliveryAddr, source.DeliveryDate, source.ClientID, source.UnitCub);

这个语句会先查询Q_SaleOrder表中满足条件的前1000行记录，然后与Q_SaleOrder2Other表进行合并。如果在Q_SaleOrder2Other表中找不到相同OrderID的记录，则插入新记录；否则跳过。主键为OrderID，因此如果目标表中已经存在该主键，则会自动跳过。