select MyField = case CASE type WHEN 0 THEN '我的' WHEN 1 THEN '它的' WHEN 2 THEN '你的' END from MyTab
select (case MyField when 0 then '我的' when q then '你的' when 2 then '它的' end) as MyField from yourtable
select MyField = case MyField WHEN 0 THEN '我的' WHEN 1 THEN '它的' WHEN 2 THEN '你的' END from MyTab
SELECT 'MyField' = CASE MyField WHEN 0 THEN '我的' WHEN 2 THEN '它的' WHEN 1 THEN '你的' END FROM yourTable
用Case来解决!其语法如下: Simple CASE function:CASE input_expression WHEN when_expression THEN result_expression [ ...n ] [ ELSE else_result_expression ] END Searched CASE function:CASE WHEN Boolean_expression THEN result_expression [ ...n ] [ ELSE else_result_expression ] END故: select MyField = case MyField WHEN 0 THEN '我的' WHEN 1 THEN '它的' WHEN 2 THEN '你的' END from MyTable
case CASE type
WHEN 0 THEN '我的'
WHEN 1 THEN '它的'
WHEN 2 THEN '你的'
END
from MyTab
when q then '你的'
when 2 then '它的' end) as MyField from yourtable
case MyField
WHEN 0 THEN '我的'
WHEN 1 THEN '它的'
WHEN 2 THEN '你的'
END
from MyTab
FROM yourTable
Simple CASE function:CASE input_expression
WHEN when_expression THEN result_expression
[ ...n ]
[
ELSE else_result_expression
]
END Searched CASE function:CASE
WHEN Boolean_expression THEN result_expression
[ ...n ]
[
ELSE else_result_expression
]
END故:
select MyField =
case MyField
WHEN 0 THEN '我的'
WHEN 1 THEN '它的'
WHEN 2 THEN '你的'
END
from MyTable