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;
--或者
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;