select 编号=s.UserID,姓名=s.userName,writtex=case when writtex is null then '缺考' else convert(varchar(5),writtex) end,Laxem=case when Laxem is null then '缺考'else convert(varchar(5),Laxem) end from Userstu as s left join UserClass as c on c.ClassID=s.userID
怎样才能将writtex和Laxem的列改成中文机试成绩和笔试成绩啊?
怎样才能将writtex和Laxem的列改成中文机试成绩和笔试成绩啊?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货