Case SQL statements of Usage

 

Code as below:

Remark by Jimmy Jun 20th 2010

代码

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