SQL_1

select *,case MyColumnName when '0' then '出区' when '1' then '入区' end as MyColumnName
from MyTableName
posted @ 2004-11-22 20:34  活力豆  阅读(354)  评论(0)    收藏  举报