Posted on 2010-01-25 14:25
Prayer 閱讀(9400)
評論(0) 編輯 收藏 引用 所屬分類:
數據庫,SQL 、
DB2
注意要加括號，在更改多個列的時候
ALTER proc usp_clearActiveScoreCalcCommentScore
as
begin
update tbForum set UltimoScore=
(case
when AllScore-RemainScore<0 then 0
else AllScore-RemainScore
end),AllScore=
(case
when ActivityDegree>=0 and ActivityDegree<=300 then 250
when ActivityDegree>=301 and ActivityDegree<=800 then 500
when ActivityDegree>=801 and ActivityDegree<=2000 then 1000
when ActivityDegree>=2001 and ActivityDegree<=4000 then 2000
when ActivityDegree>=4001 and ActivityDegree<=8000 then 4500
when ActivityDegree>8000 then 9000
end),UltimoDegree=ActivityDegree,ActivityDegree = 0
update tbForum set RemainScore=AllScore
end