If you are using the MDAC SQLODBC driver with MSDASQL or MDAC SQLODBC driver with ADO, use OLE DB in SQL Server Native Client.
Because it has been so universally adopted, you can use it to share a wide range of data across heterogeneous systems, as long as the XML conforms to ISO standards.Why not just store the XML as documents in a file system.In some cases, you should use large object storage such as varchar(max) or nvarchar(max).The simplest way to retrieve an individual value from an XML instance is to use the value() method, one of the five methods available to the xml data type.The data type supports several methods that let you query and modify individual elements, attributes, and their values directly within the XML instance, rather than having to work with that instance as a whole.We could have just as easily created an XML structure that describes people, places, or other things.
MDAC provides functionality such as tracing, management controls, and performance counters.
In addition, the xml data type ensures that each XML instance is, at the very least, well formed according to ISO standards.
The SQL Server Native Client OLE DB provider and ODBC driver names are different from those used with MDAC.
value( xquery_exp , data_type ) XQuery is a scripting language used to access XML data.
The schema specifies the types of elements and attributes permitted in the XML and how those components should be ordered and hierarchically preserved.
The following XML demonstrates the basic components of an XML document: Black 35,600 Elements represent the building blocks of in an XML instance.