UPDATE [Table1]
SET [StatuID] = CASE WHEN [StatuID] - 1 < 0 THEN 0 ELSE [StatuID] - 1 END
WHERE [IndexId] = @IndexId;
case 用在 UPDATE
最新推荐文章于 2020-07-02 19:57:37 发布
UPDATE [Table1]
SET [StatuID] = CASE WHEN [StatuID] - 1 < 0 THEN 0 ELSE [StatuID] - 1 END
WHERE [IndexId] = @IndexId;