sql server - How to retrieve XML that contains CDATA, from Database -
i need retrieve xml in following format
<mv> <v>!cdata[[some_inner_xml_1]]</v> <v>!cdata[[some_inner_xml_2]]</v> </mv>
i learned data in <v />
other xml. when thought data integer, wrote , worked
select identifiertext 'v' ipmruntime.recordstoexport batchid = 5 xml path(''), root('mv')
i trying use syntax 'v!cdata'
- doesn't it. don't know stick cdata
in it
i tried syntax
select 1 tag, null parent, identifiertext 'mv!1!v!cdata' ipmruntime.recordstoexport batchid = 5 xml explicit, root('mv')
it results in need
<mv><mv><v><![cdata[47f81be4-b54f-4703-840b-62b306c40842]]></v></mv><mv><v><![cdata[3ba36a1f-bf75-4ed9-911e-26f10fba5587]]></v></mv></mv>
or, if use 'v!1'
in same query, give me <mv><v></v><v></v></mv>
goes cdata?
but has each <v>
wrapped <mv>
. obviously, not great xml/sqlserver combo...
you can way :
select 1 tag, null parent, identifiertext [v!1!!cdata] --[tag name!tag type!tag attribute!other optional setting] ipmruntime.recordstoexport batchid = 5 xml explicit, root('mv')
Comments
Post a Comment