update tbl_user set SHENGXIAO=(select case when year(@temp1)%12 = 0 then '8'
when year(@temp1)%12 = 1 then '9'
when year(@temp1)%12 = 2 then '10'
when year(@temp1)%12 = 3 then '11'
when year(@temp1)%12 = 4 then '0'
when year(@temp1)%12 = 5 then '1'
when year(@temp1)%12 = 6 then '2'
when year(@temp1)%12 = 7 then '3'
when year(@temp1)%12 = 8 then '4'
when year(@temp1)%12 = 9 then '5'
when year(@temp1)%12 = 10 then '6'
when year(@temp1)%12 = 11 then '7'
end)from tbl_user where ID=@i
when year(@temp1)%12 = 1 then '9'
when year(@temp1)%12 = 2 then '10'
when year(@temp1)%12 = 3 then '11'
when year(@temp1)%12 = 4 then '0'
when year(@temp1)%12 = 5 then '1'
when year(@temp1)%12 = 6 then '2'
when year(@temp1)%12 = 7 then '3'
when year(@temp1)%12 = 8 then '4'
when year(@temp1)%12 = 9 then '5'
when year(@temp1)%12 = 10 then '6'
when year(@temp1)%12 = 11 then '7'
end)from tbl_user where ID=@i