--插入一下臨時資料源
with m as(
select '張三' name,'語文'course,'89'score union all
select '張三' name,'數學'course,'100'score union all
select '張三' name,'英語'course,'40'score union all
select '張三' name,'物理'course,'93'score union all
select '張三' name,'地理'course,'95'score union all
select '張三' name,'化學'course,'80'score union all
select '李四' name,'語文'course,'89'score union all
select '李四' name,'數學'course,'100'score union all
select '李四' name,'英語'course,'40'score union all
select '李四' name,'物理'course,'93'score union all
select '李四' name,'地理'course,'95'score union all
select '李四' name,'化學'course,'80'score
)select * into #info from m
select * from #info
--STUFF 拼接
select distinct name,
STUFF((
SELECT '|' + course+'='+score+'分'
FROM #info B
WHERE B.name=A.name FOR XML PATH('')), 1, 1, '') '拼接串'
from #info A
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/296434.html
標籤：SQL Server