CDATA using xml explicit

Question

CDATA using xml explicit

kunaal desai

Mr or Mrs. 500

Points: 506
More actions
January 15, 2011 at 2:47 pm

#388645

Hello guys,
I have someting like this:
select * from
(
select
Document_Template_Structure_Text as docTemplateTXT
from
Document_Template_Type
where
Document_Template_Type_Name = @Template_Name
) as docData
for xml auto, root('Document')
Now, i need to convert the returning column into CDATA. I am not sure how to do it. I know that I have to use XMl EXPLICIT for that. But I am not sure how to use it in this context.
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

LutzM SSC Guru Points: 107049 More actions · Answer 1

If you would provide some ready to use sample data as described in the first link in my signature together with your expected result I'm confident we can help you.

Based on the information so far all I can suggest is: look at the samples in BOL.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

mister.magoo SSC-Forever Points: 47174 More actions · Answer 2

Have a read of this Blog Post on BeyondRelational.com : http://beyondrelational.com/blogs/jacob/archive/2010/02/06/how-to-generate-cdata-and-namespace-declarations-using-for-xml-explicit.aspx

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);