SqlServer2008r2在查询时将两列合并显示

SELECT Sno 学号,姓名性别=ltrim(Sname)+LTRIM(Ssex) FROM Student;


--或者
SELECT Sno AS 学号,LTRIM(Sname)+LTRIM(Ssex) AS 姓名性别 FROM Student;


--或者
SELECT Sno AS 学号,姓名性别=CAST(Sname as varchar(10))+CAST(Ssex as varchar(10)) FROM Student;