Oracel: select user_name, user_password, decode(user_status, 0, '取消', 1, '完成', 2, '接受') user_status from USERS SQL Server: select user_name, user_password, case user_status when 0 then '取消' when 1 then '完成' when 2 then '接受' end user_status from USERS
select user_name, user_password, case user_status when 0 then '取消' when 1 then '完成' else '接受' end as user_status from [users]
select user_name ,user_password ,case user_statu when 0 then '取消' when 1 then '完成' when 2 '接受' else '' end as user_statu from [user]
select user_name ,user_password, case user_status when 0 then '取消' when 1 then '完成' when 2 then '' end from users
你这是要在c# 里面读取吗?要是在C#里面读取的话直接在给实体类赋值的时候判断下在赋给实体类不就行了。如果用sql语句的话 用case..when .. then 应该能实现。不过我忘记怎么用了 。你可以去查下
典型的case.when: select user_name ,user_password, case user_status when 0 then '取消' when 1 then '完成' when 2 then '' end from users
SQL Server: select user_name, user_password, case user_status when 0 then '取消' when 1 then '完成' when 2 then '接受' end user_status from USERS
select user_name, user_password, decode(user_status, 0, '取消', 1, '完成', 2, '接受') user_status from USERS
SQL Server:
select user_name, user_password,
case user_status
when 0 then
'取消'
when 1 then
'完成'
when 2 then
'接受'
end user_status
from USERS
user_name
,user_password
,case user_statu when 0 then '取消' when 1 then '完成' when 2 '接受' else '' end as user_statu
from [user]
用case..when .. then 应该能实现。不过我忘记怎么用了 。你可以去查下
典型的case.when:
select user_name ,user_password, case user_status when 0 then '取消' when 1 then '完成' when 2 then '' end from users
SQL Server:
select user_name, user_password,
case user_status
when 0 then
'取消'
when 1 then
'完成'
when 2 then
'接受'
end user_status
from USERS