sqlserver 查询结果赋值到Excel会出现换行

SELECT REPLACE(MaterialCode, CHAR(13) + CHAR(10), ''),REPLACE(MaterialCode, CHAR(13), ''),REPLACE(MaterialCode, CHAR(10), '')
FROM #MeetingPlan2023 where isnull(MaterialCode,'')!=''
and ID=22264

 

SELECT REPLACE(MaterialCode, CHAR(13) + CHAR(10), ''),REPLACE(MaterialCode, CHAR(13), ''),REPLACE(MaterialCode, CHAR(10), '')
FROM #MeetingPlan2023 where isnull(MaterialCode,'')!=''
and ID=22264

--有效

SELECT REPLACE(MaterialCode, CHAR(13) + CHAR(10), ''),REPLACE(MaterialCode, CHAR(13), ''),REPLACE(MaterialCode, CHAR(10), '')
FROM #MeetingPlan2023 where isnull(MaterialCode,'')!=''
and ID=22264

 

--直达版本

REPLACE(REPLACE(REPLACE(REPLACE(a.NickName, '"', ''), CHAR(13), ''), CHAR(10), ''), CHAR(9), '') '微信昵称',

 

示例：