求一个CASE...WHEN
本帖最后由 bulls5988 于 2012-09-20 15:09:21 编辑 我想让 remaining_nums <= 0 时，显示‘车位已满’ remaining_nums > 0 时，显示数字 比如：55 这个SQL怎么写呢？
string sql_str = "select remaining_id as 序号,remaining_name as 收费口位置,remaining_nums as 可用车位数
,remaining_nums_used as 已用车位数,remaining_nums_all as 总车位数,remaining_flag as 车场开放 from
car_park_remaining";
select remaining_id as 序号,remaining_name as 收费口位置,CASE WHEN ISNULL(remaining_nums,0)<=0 THEN '车位已满' WHEN ISNULL(remaining_nums,0)>0 THEN CONVERT(varchar(8),remaining_nums) END as 可用车位数
,remaining_nums_used as 已用车位数,remaining_nums_all as 总车位数,remaining_flag as 车场开放
from car_park_remaining
