Case SQL statements of Usage
Code as below:
Remark by Jimmy Jun 20th 2010
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
1、无标题
select ltrim(a.prodid),
case ProdStatus
when 0 then '已创建' when 1 then '已估计'
when 2 then '已计划' when 3 then '已发放'
when 4 then '已开始' when 5 then '生产入库'
when 6 then '成本已核算'when 7 then '已结束' end
,a.createddate,b.[name]
from prodtable a
-------------------------------------
2、有标题一
select ltrim(a.prodid),'工单状态' =
case ProdStatus
when 0 then '已创建' when 1 then '已估计'
when 2 then '已计划' when 3 then '已发放'
when 4 then '已开始' when 5 then '生产入库'
when 6 then '成本已核算'when 7 then '已结束' end
,a.createddate,b.[name]
from prodtable a
-------------------------------------
3、有标题二
select ltrim(a.prodid),
case ProdStatus
when 0 then '已创建' when 1 then '已估计'
when 2 then '已计划' when 3 then '已发放'
when 4 then '已开始' when 5 then '生产入库'
when 6 then '成本已核算'when 7 then '已结束' end AS '工单状态'
,a.createddate,b.[name]
from prodtable a
-------------------------------------
4、有标题,但没有省略
select ltrim(a.prodid),
'工单状态' = case
when ProdStatus = 0 then '已创建' when ProdStatus = 1 then '已估计'
when ProdStatus = 2 then '已计划' when ProdStatus = 3 then '已发放'
when ProdStatus = 4 then '已开始' when ProdStatus = 5 then '生产入库'
when ProdStatus = 6 then '成本已核算' when ProdStatus = 7 then '已结束' end
,a.createddate,b.[name]
from prodtable a