I have an ordered list of elements in Xml and I need to return their
position in the xml, something along the lines of value('position()', 'int')
I have no problem in filtering the list by changing the xpath to
@Xml.nodes('//doc/MPR [position()=1]') but I've not found a way of ...

If we search an XML datatype, does it use the collation properties
from the database, e.g. Case sensitivity, Accent sensitivity?
If it doesn't use the database, is there any other way of affecting
it?

Why Microsoft stops support for http endpoints - native xml web services
technology in future versions of MSSQL?
Thnx

I have the following
declare @xml XML;
set @xml = '<?xml version="1.0" encoding="UTF-8"
?><IDs><ID><ReferralID>8</ReferralID></ID>

All:
In SQL 2005, I’ve got an XML column called ‘CurrentConfig’ in a table called
‘Computers’.  I just added a second schema to the schema collection.  The
initial schema had no associated namespace (i.e. the “no namespace”

I need to store a record with 16 fields, each with up to 360,000 values of a
2 bytes integer.
Storing each value in a field is quite a crazy
idea(value1,value2,...,value360000),

SQL Server 2008
XML files with and without Schemas
I am trying to load mulitple XML files from a file into my Database.  Each
XML file will relate to a table.