download the application please visit www.mrbool.com/player
Title: E-learning-XML ON SQL SERVER 2005–Lesson 07
Duration: 17:02 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 retrieve relational data formatted as a XML Fragment using the FOR XML EXPLICIT clause, make well formed XML document using ROOT clause, deal with null values and how to convert to XML data type.
Technologies Used: Sql Server 2005.
Keywords:Sql Server 2005, XML, EXPLICIT, ROOT.