I just posted a reply above, which has an example of extracting values from xml attributes and nodes, using "value" method.

I just posted a reply above, where i presented an example which extracts values from attributes and XML nodes.

You are right. I will correct this.

could you give me a more precise problem description? i will get back to you with a working example then.

hi ryan,

Let me present a quick example:

<orderInfo>

<item code="A001" category="FOOD" subcategory="Candies">

<description>Nestle Munch</description>

<qty>10</qty>

<rate>11.25</rate>

</item>

<item code="A002" category="FOOD" subcategory="Biscuits">

<description>Britania Good Day</description>

<qty>15</qty>

<rate>12.25</rate>

</item>

</orderInfo>

The following example extracts the attribute values:

SELECT

x

.

It is set from the "FROM" clause. Look at the following:

........FROM @x.nodes('//salesOrder') AS x(header)

Does this answer your question? It is a type of alias that we assign to the resultset.

Hi,

In part III of this series, I have presented the sample code which handles the insert/update/delete scenario. When a sales order is edited, a few new items may be added,...

Hi Paul,

I will definitely collect some performance data and will post it soon.

Jacob

🙂

As I mentioned earlier, the last part of this 4 part article has an error handling example, where the XML handle is released if an error occurs.

Hi Confucius247,

I agree with you. Actually this article is part of a series, which demonstrates more and more features with each installment. The purpose of the first installment is to...

Hi mike,

I agree with you. There are many cases where you still need to hit the DB many times. But I suppose most of those scenarios can be avoided if...

Hi Mike,

This article presents a solution that works with SQL Server 2000 specifically. Towards the end of this series, I have an article that presents the same with the XML...