SQL UPDATE 具有复合主键的表中除某些行外的所有行

Question

我正在为 SQL 语句苦苦挣扎。

我想在具有复合主键的表中更新除某些行之外的所有行。

这就是我现在所做的:

UPDATE Products SET Active = 0

_

UPDATE Products SET Active = 1
WHERE (Id_A = 1 AND Id_B = 1 AND Id_C = 1) OR
      (Id_A = 1 AND Id_B = 2 AND Id_C = 1) OR
      (Id_A = 5 AND Id_B = 8 AND Id_C = 3) OR
       .
       .
       .
       etc

这有效，但我不喜欢它。我希望能够一次性完成。

有没有办法在 SQL 中做到这一点？

Answer 1

你的意思是这样的:

UPDATE Products SET Active = CASE WHEN
      (Id_A = 1 AND Id_B = 1 AND Id_C = 1) OR
      (Id_A = 1 AND Id_B = 2 AND Id_C = 1) OR
      (Id_A = 5 AND Id_B = 8 AND Id_C = 3) OR
       .
       .
       .
       THEN 1 ELSE 0 END