求助，sql拼接问题select A.NO || 字符串 AS Msg from ANO是数值类型，要怎样拼才正确[解决办法]select co
求助，sql拼接问题
select A.NO || '字符串' AS Msg from A
NO是数值类型，要怎样拼才正确
[解决办法]
select convert(varchar(10),A.NO)+'字符串' AS Msg from A
长度10自己改
求助，sql拼接问题
select A.NO || '字符串' AS Msg from A
NO是数值类型，要怎样拼才正确
[解决办法]
select convert(varchar(10),A.NO)+'字符串' AS Msg from A
长度10自己改