Re: Getting all nodes and node details from xml using xquery
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Sat, 8 Apr 2006 09:47:06 +0000 (UTC)
Shilpa (shilpa.nagavara@xxxxxxxxxx) 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@xxxxxxxxxxxxx
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
.
- References:
- Prev by Date: Re: Maximum number of records per second that can be inserted into SQLServer 2000.
- Next by Date: Re: Auto Number
- Previous by thread: Getting all nodes and node details from xml using xquery
- Next by thread: Re: Getting all nodes and node details from xml using xquery
- Index(es):
Relevant Pages
|
