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
posted on 2010-08-31 18:06 左直拳 阅读(125) 评论(0) 编辑 收藏 举报