mssql 2个字段合并

SELECT rtrim(Numer)+rtrim(Id) as numer FROM AskReservation 可用rtrim/ltrim/cast/convert--楼主参照联机用法