SQL SQL Server、Access - Code Recipes

计算字段 / 拼接字段

SELECT Code + ' - ' + Name
FROM country

Code + ' - ' + Name

ABW - Aruba

AFG - Afghanistan

AGO - Angola

AIA - Anguilla

ALB - Albania

AND - Andorra

ANT - Netherlands Antilles

ARE - United Arab Emirates

ARG - Argentina

...

拼接把几个值首尾相接，合成一个较长的值。