Viewing 13 posts - 376 through 388 (of 388 total)
I just posted a reply above, which has an example of extracting values from xml attributes and nodes, using "value" method.
April 13, 2007 at 4:28 am
I just posted a reply above, where i presented an example which extracts values from attributes and XML nodes.
April 13, 2007 at 4:26 am
could you give me a more precise problem description? i will get back to you with a working example then.
April 13, 2007 at 4:18 am
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
.
April 13, 2007 at 4:05 am
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.
April 13, 2007 at 3:53 am
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,...
March 27, 2007 at 11:47 pm
Hi Paul,
I will definitely collect some performance data and will post it soon.
Jacob
March 27, 2007 at 10:42 am
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.
March 27, 2007 at 8:24 am
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...
March 27, 2007 at 3:39 am
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...
March 26, 2007 at 11:46 pm
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...
March 26, 2007 at 11:39 pm
Viewing 13 posts - 376 through 388 (of 388 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy