526互联

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

发布时间 2024-01-10 14:47:26作者: 小易儿

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

 

示例：