case 用在 UPDATE

    UPDATE [Table1]
        SET [StatuID] = CASE WHEN [StatuID] - 1 < 0 THEN 0 ELSE [StatuID] - 1 END
        WHERE [IndexId] = @IndexId;

IsExcellent = CASE ISNULL(ex.MmId,0) WHEN 0 THEN 0 ELSE 1 END

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/leftfist/p/4258155.html