Database Management White Papers
XML Best Practices for Microsoft SQL Server 2005
Overview Microsoft SQL Server 2005 provides extensive support for XML data processing. XML values can be stored natively in an XML data type column, which can be typed according to a collection of XML schemas, or left untyped. You can index the XML column. Furthermore, fine-grained data manipulation is supported using XQuery and XML DML, the latter being an extension for data modification. SQL Server 2000 and SQLXML Web Releases provide powerful XML data management capabilities. These features focus on mapping between relational and XML data. XML views of relational data can be defined using annotated XSD (AXSD) to provide an XML-centric approach that supports the bulkload of data, query, and update capabilities on XML data.
| Publisher | Microsoft | File Format | HTML |
|---|---|---|---|
| Date Published | June 2004 | Downloads | 6 |
| Format | White Papers | ||
| Topics | |||



