SQL SELECT 连接两个字段
select time_stamp,B_CEQPT+‘/’+B_SEQPT as EQUIP from FDPS
B_CEQPT和B_SEQPT是两个字段名,类型为char,想把两个字段用‘/’连在一起显示
单独查询 select time_stamp,B_SEQPT as EQUIP from FDPS和select time_stamp,B_CEQPT as EQUIP from FDPS都是可以显示的
因为B_CEQPT和B_SEQPT的字符串长度不一定,试过select time_stamp, rtrim(B_CEQPT)+'/'+rtrim(B_SEQPT) as EQUIP from FDPS还是不行,查询得到EQUIP那一栏的结果全部都是0
这个到底问题在哪