Posted by Shilpa on 04/06/06 13:42

Hi,

I haev the following code:

DECLARE @x xml
SET @x='
<Root>
<row id="1"><name>Larry</name><oflw>some text</oflw></row>
<row id="2"><name>Joe</name></row>
<row id="3" />
</Root>
'
exec sp_xml_preparedocument @idoc OUTPUT, @x
SELECT * FROM OPENXML(@idoc, '/Root')

This gives the following details
id
parentid
nodetype localname

prefix

namespaceuri
datatype

prev text



I want to get the same details using XQuery, please let me know how to
go about it.

Regards,
Shilpa

• Next in forum: Re: SQL Server 2005 vs Oracle
• Prev in forum: SQL server express 2005 local accounts problem. please help!
• Thread view: Getting all nodes and node details from xml using xquery

[Reply to this message]