改变 sql xml auto 的视图/样式

Question

我有下面的代码（接着我之前的问题 SQL How to list Columns in a Table as a Cursor Statement)

select 
    (select * from
        (select Narrative 
         from OfficeClientLedger
         where ptMatter=$Matter$ and ptTrans = 4) 
     as Disbursments for xml auto)

它返回

<OFFICECLIENTLEDGER NARRATIVE="M0604/20 Cwm Taff NHS Trust Medical Records (C)"/><OFFICECLIENTLEDGER NARRATIVE="M0604/210 Dr Purby Medeical Records (C)"/><OFFICECLIENTLEDGER NARRATIVE="M0604.20 Orchid Cellmark tld Fee"/><OFFICECLIENTLEDGER NARRATIVE="M0604/20 Parsons Dowd Psychological Ltd Assessment Fees"/><OFFICECLIENTLEDGER NARRATIVE="M0604/20 Dr R  Oretti Drug testing"/><OFFICECLIENTLEDGER NARRATIVE="M0604/20 Correction of MIssposting CQ 013524"/><OFFICECLIENTLEDGER NARRATIVE="M0604/20 Helen Blackler Assessment Fees (P) "/> 

但是，我需要它给我带来一个列表，例如

M0604/20 Cwm Taff NHS 信托医疗 记录（C）

M0604/210 Purby 博士医疗记录 （三）

M0604.20 Orchid Cellmark tld 费用

M0604/20 帕森斯多德

M0604/20 Dr R Oretti 药物测试

M0604/20 错误发布 CQ 的更正 013524

M0604/20 海伦·布莱克勒评估 费用（P）

有什么想法吗？谢谢

Answer 1

select
(select cast(Narrative as varchar(max))
from OfficeClientLedger
where ptMatter=$Matter$ and ptTrans = 4
as Disbursments for xml path(''), true)

Answer 2

您可以使用 XSL 样式表来更改从 SQL Server 检索到的 XML 的格式。

http://sqlxml.org/faqs.aspx?faq=99