这条语句只能在sql server2000中使用,在其它地方使用还没有经过验证
select userid,loginname,username,gender=case when gender=1 then '男' else '女' end,Mobile,Remark
from userinfo order by userid desc
select userid,loginname,username,gender=case when gender=1 then '男' else '女' end,Mobile,Remark
from userinfo order by userid desc