您可以使用MERGE
sql Server中的语法执行“ upsert”操作:
MERGE [SoMetable] AS target
USING (SELECT @FruitID, @CrateID) AS source (FruitID, CrateID)
ON (target.FruitID = source.FruitID)
WHEN MATCHED THEN
UPDATE SET CrateID = source.CrateID
WHEN NOT MATCHED THEN
INSERT (FruitID, CrateID)
VALUES (source.FruitID, source.CrateID);
update [SoMetable] set CrateID = @CrateID where FruitID = @FruitID
if @@rowcount = 0
insert [SoMetable] (FruitID, CrateID) values (@FruitID, @CrateID)