Posted by Erland Sommarskog on 10/02/26 11:44

Shilpa (shilpa.nagavara@unisys.com) writes:
> 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')
>...
> I want to get the same details using XQuery, please let me know how to
> go about it.

I am not sure that you can to this easily. You use a very special form
of OPENXML, the one without a WITH clause, that gives you an edge table.
I have never found any use for edge tables, but maybe I've overlooked
something.

Since I'm no specialist in XML, I've consulted my MVP colleagues who know
this topic better, so hopefully I will be able to return with a more
definitive answer.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]