先用cast转成字符串类型,再用加号连接

select cast(1 as VARCHAR(10))+cast(2 as VARCHAR(10))
复制