Removing all values from an XML Document
- From: "Mark" <marksullivan@xxxxxxx>
- Date: Fri, 29 Dec 2006 09:24:12 -0500
Is there an easy way in SQL Server to take an XML Document and remove all
its values while leaving the structure, elements and attributes in place?
I have included a sample of what I would like below
For example take:
'<root>
<foo name="Joe"/>
<heading name="One">
<contents>some text</contents>
</heading>
</root>'
and return:
'<root>
<foo name=""/>
<heading name="">
<contents></contents>
</heading>
</root>'
.
- Follow-Ups:
- Prev by Date: RE: Thoughts on storing address data with XML data type?
- Next by Date: RE: Thoughts on storing address data with XML data type?
- Previous by thread: schema collection problem?
- Next by thread: Re: Removing all values from an XML Document
- Index(es):