62,052
社区成员
发帖
与我相关
我的任务
分享
SELECT [Message]= STUFF(REPLACE(REPLACE(
(
SELECT Message FROM MessageOllie内容
WHERE OrderID = 41
FOR XML AUTO
), '内容 value="', ','), '"/>', ''), 1, 1, '')
create table tb(id int, value varchar(10))
insert into tb values(1, 'aa')
insert into tb values(1, 'bb')
insert into tb values(2, 'aaa')
insert into tb values(2, 'bbb')
insert into tb values(2, 'ccc')
go
-- 查询处理
SELECT * FROM(SELECT DISTINCT id FROM tb)A OUTER APPLY(
SELECT [values]= STUFF(REPLACE(REPLACE(
(
SELECT value FROM tb N
WHERE id = A.id
FOR XML AUTO
), ' <N value="', ','), '"/>', ''), 1, 1, '')
)N