Getting All Nodes And Node Details From Xml Using Xquery

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