insert into 天气表(天气字段)
values case cast(rand()*100 as int)%7
when 0 then '晴天'
when 1 then '多云'
when 2 then '阴'
when 3 then '小雨'
when 4 then '大雨'
when 5 then '阵雨'
else '暴雨' end
insert into 天气表(天气字段)
values cast(rand()*100 as int)%7
when 0 then '晴天'
when 1 then '多云'
when 2 then '阴'
when 3 then '小雨'
when 4 then '大雨'
when 5 then '阵雨'
else '暴雨' end