SQL将两列合并为一列:
结构:
select cast(列名 as 类型) + cast(列名 as 类型) as 新列名称 from 表
select (CAST( FirstName as nvarchar) + CAST(LastName as nvarchar)) AS Name from employees;
SQL将两列合并为一列:
结构:
select cast(列名 as 类型) + cast(列名 as 类型) as 新列名称 from 表
select (CAST( FirstName as nvarchar) + CAST(LastName as nvarchar)) AS Name from employees;