SELECT *,(case when sex = 1 then '男' else '女' end)as sex1 FROM [PMTS].[dbo].[UserInfo]
转载于:https://www.cnblogs.com/zll922/archive/2010/03/09/1681456.html
SELECT *,(case when sex = 1 then '男' else '女' end)as sex1 FROM [PMTS].[dbo].[UserInfo]
转载于:https://www.cnblogs.com/zll922/archive/2010/03/09/1681456.html