Title: E-learning-XML ON SQL SERVER 2005–Lesson 10 (End)
Duration: 15:55 min
Summary:XML is a multipurpose, extensible data representation technology that expands the possibilities for how applications can consume and manipulate data. Unlike relational data, XML data can represent structured, semi structured, and unstructured data. XML support in SQL Server 2005 is fully integrated with the relational engine and query optimizer, allowing the retrieval and modification of XML data and even the conversion between XML and relational data representations.This E-learning course shows you how to retrieve and modify XML data, and describes how to convert between XML and relational data. You also see how you can optimize the new XML data type in SQL Server 2005 for data retrieval by using different types of indexes.In this lesson you will learn:
• How to transform XML Data into Relational Data
• How to use OPENXML
• How to use sp_xml_preparedocument
• How to use sp_xml_removedocument
Technologies Used: Sql Server 2005.
Keywords: Sql Server 2005, XML, OPENXML, sp_xml_removedocument, sp_xml_preparedocument.