I have an untyped xml field in SQL 2008 that looks something like this...

<Root>
<Feed id="1">
<test>System</test>
<testb>wsidGeneric</testb>
</Feed>
</Root>

I would like the id field to automatically increment giving a unique
identifier whenever a new xml record is inserted. I think this is possible
but I’m not sure how to go about it. Could someone please give advice or
point me to a good url where I can learn how to implement this please?

Thanks,

Paul.