Название: Stairway to SQL Server XML
Автор: Robert Sheldon
Издательство: SimpleTalk Publishing
ISBN: 978-1-910035-14-6
Год: 2017
Страниц: 118
Язык: английский
Формат: True PDF
Размер: 64.2 MB

Although XML is conceptually simple, its use as an equal partner datatype within a relational database, with full searching, validation and manipulation of data, is not intuitive. XML has been part of the SQL Standard since 2003, and is essential for any DBA because so many of the dynamic management views return XML data. Now that the industry is more used to data defined by document markup, it is becoming more important than ever for Database Developers and DBAs to understand the technology and to know where it makes sense to use XML. In this book, originally a series of articles on SQLServerCentral.com, Robert Sheldon flexes his talent to make the complicated seem simple.

Table of Contents:
Level 1 – Introduction to XML 8
Level 2 – The XML Data Type 17
Level 3 – Working with Typed XML 24
Level 4 – Querying XML Data 36
Level 5 – The XML exist() and nodes() Methods 51
Level 6 – Inserting Data into an XML Instance 64
Level 7 – Updating Data in an XML Instance 77
Level 8 – Deleting Data from an XML Instance 89
Level 9 – Creating XML-based Functions 99
Level 10 – Converting XML Data 110