sql server 将两列数据合并到一列 拼接

create table a(
s nvarchar null,
ss nvarchar null,
f decimal(18,1) null,
ff decimal(18,1) null,
)
INSERT INTO a VALUES(2,2,6.0,6.0);
INSERT INTO a VALUES(1,4,1.3,1.4);

select cast(s as varchar)+ss as str from a 

 

select cast(f as varchar(10))+''+cast(ff as varchar(10)) as v from a

 

 

select cast(列1 as varchar(10))+''+cast(列2 as varchar(10)) as 别名 from 表名