A,B,C,D各是什么数据类型,不一样的话用cast做转换再拼接比较保险.select cast(A as varchar)+cast(B as varchar)+cast(C as varchar)+cast(D as varchar) AS MESSAGE from test
是不是空格造成的?可以这样: select cast(A as varchar) + cast(B as varchar) + cast(C as varchar) + cast(D as varchar) AS MESSAGE from test如果只是显示的地方被截断,则无所谓,拉宽你的列名即可.
指定长度select cast(A as varchar(max)) + cast(B as varchar(max)) + cast(C as varchar(max)) + cast(D as varchar(max)) AS MESSAGE from test max+max时支持 max+8000字节
from test
select cast(A as varchar) +
cast(B as varchar) +
cast(C as varchar) +
cast(D as varchar) AS MESSAGE
from test如果只是显示的地方被截断,则无所谓,拉宽你的列名即可.
cast(B as varchar(max)) +
cast(C as varchar(max)) +
cast(D as varchar(max)) AS MESSAGE
from test
max+max时支持 max+8000字节
from testprint @x