value() method, the exist() method and the modify() method - XML on SQL Server | SQL courses

OBS: download the application please visit www.mrbool.com/player

Title: E-learning-XML ON SQL SERVER 2005–Lesson 09

 

Duration: 21:11 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 use the value() method, the exist() method and the modify() method.

Technologies Used: Sql Server 2005.

Keywords: Sql Server 2005, XML, value(), exist(),modify().