what if you have 2 namespaces in your xml? well t...

2011-12-06T12:01:34.748-06:00

what if you have 2 namespaces in your xml?

well then all you need to do is declare these namespaces next to each other , separated by a space

declare @q xml =
'

maca

twix

'

declare @h int
execute sp_xml_preparedocument @h output, @q, ''

select
*
from openxml(@h, '//comida/e:doce/s:saudavel', 2)
with([g:exemplo] varchar(max))

execute sp_xml_removedocument @h

Comments on Pettijohn.com: OPENXML and sp_xml_preparedocument with Namespaces...

what if you have 2 namespaces in your xml? well t...