Coles Pro SQL Server 2008 XML

1. ed
ISBN: 978-1-4302-0630-9
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 496 Seiten

Knowledge and ability to apply XML are de rigueur in today's world, and SQL Server developers and administrators are no exception to that rule. Pro SQL Server 2008 XML is your key to unlocking the powerful XML feature set first introduced in SQL Server 2005 and since refined in SQL Server 2008. Author Michael Coles shows how to store XML using SQL Server's built-in XML data type. Learn to query and manipulate XML data using standard technologies such as XQuery and XSLT. No SQL Server database professional can afford to be without knowledge of the XML feature set. Pro SQL Server 2008 XML delivers on the knowledge that you need to remain competitive in your career. Shows how to store, query, and manipulate XML documents in SQL Server Provides step-by-step examples showing best practices and advanced features Accurately discusses how SQL Server's XML feature set stacks up against the ISO XML standards

Michael Coles has more than a decade's experience designing and administering SQL Server databases. A prolific writer of articles on all aspects of SQL Server, particularly on the expert use of T-SQL, he holds MCDBA and MCP certifications. He graduated magna cum laude with a bachelor of science degree in information technology from American Intercontinental University in Georgia. A member of the United States Army Reserve, he was activated for two years following 9/11.

Autoren/Hrsg.

Coles, Michael

Inhaltsverzeichnis

1;Contents at a Glance;5
2;Contents;6
3;Foreword;13
4;About the Author;15
5;About the Technical Reviewer;16
6;Acknowledgments;17
7;Introduction;18
7.1;Who This Book Is For;18
7.2;How This Book Is Structured;19
7.3;Conventions;22
7.4;Prerequisites;23
7.5;Downloading the Code;23
7.6;Contacting the Author;23
8;Enter XML;24
8.1;Looking Back at SQL Server XML;24
8.2;What Is XML?;25
8.3;Defining XML Data;27
8.4;Considering Other Formats;31
8.5;When to Use XML;34
8.6;What’s New in SQL Server 2008 XML;36
8.7;Summary;39
9;FOR XML and Legacy XML Support;40
9.1;Using the FOR XML Clause;40
9.2;Using XPath Node Tests;60
9.3;Adding Namespaces to FOR XML;68
9.4;Creating Complex FOR XML Queries;70
9.5;OPENXML Rowset Provider;77
9.6;OPENROWSET XML Loading;81
9.7;Summary;82
10;The xml Data Type;83
10.1;Creating xml Instances;83
10.2;Creating Well-Formed and Valid XML;87
10.3;Using XML Type Methods;93
10.4;Summary;103
11;XML Schema Collections;104
11.1;Introducing XML Schema;104
11.2;Constraining Occurrences;116
11.3;Extending XML Schemas with Wildcards;123
11.4;Typing XML;129
11.5;Summary;135
12;XQuery;136
12.1;Introducing the XQuery Language;136
12.2;Creating XQuery Queries;140
12.3;Using FLWOR Expressions;154
12.4;Constructing XML with XQuery;157
12.5;Using the SQL Server xml Methods;160
12.6;Maximizing XQuery Performance;168
12.7;Summary;172
13;XQuery Functions and Operators and XML DML;173
13.1;Using Operators;174
13.2;Using XQuery Type Expressions;176
13.3;Using XQuery Functions;178
13.4;Modifying XML with XML DML;191
13.5;Summary;196
14;Indexing XML;197
14.1;Creating a Primary XML Index;197
14.2;Creating Secondary XML Indexes;201
14.3;Full-Text Indexing XML;209
14.4;Summary;212
15;XSLT and the SQLCLR;213
15.1;Transforming XML;213
15.2;Performing a Back-End Transformation;228
15.3;Advanced XSL Transformations;239
15.4;Summary;248
16;HTTP SOAP Endpoints;250
16.1;Creating Endpoints;251
16.2;Consuming Endpoints;259
16.3;Summary;263
17;.NET XML Support;264
17.1;XML Validation;264
17.2;Accessing XML on the Web;272
17.3;REST Services;275
17.4;.NET XML Classes;280
17.5;Summary;293
18;Spatial Data and GML;294
18.1;Spatial Data;294
18.2;Populating Spatial Data;295
18.3;GML;299
18.4;Summary;312
19;SQLXML;313
19.1;Querying;313
19.2;Updategrams;316
19.3;Bulk Loading;328
19.4;Querying SQLXML with XPath;332
19.5;Summary;335
20;LINQ to XML;336
20.1;Functional Construction;336
20.2;Loading XML from Other Sources;338
20.3;Querying XML;347
20.4;Transforming XML;354
20.5;Summary;356
21;XML Support Tools;357
21.1;Bulk Copy Program;357
21.2;XML for Analysis;359
21.3;SQL Server Integration Services;361
21.4;XML Query Plans;363
21.5;Database Tuning Advisor;365
21.6;XMLSpy;366
21.7;Web Browsers;368
21.8;Visual Studio;370
21.9;Summary;370
22;W3C and Other References;372
22.1;W3C Specifications;372
22.2;Other Useful Documents;374
23;SQL Server XQuery Data Types;376
24;XML Schema Reference;380
24.1;Element Information Items;380
24.2;XML Schema Data Type Facets;387
25;XQuery/XPath/XML DML Quick Reference;389
25.1;XPath;389
25.2;XQuery;391
25.3;XML DML;394
26;XSLT 1.0 and XPath 1.0 Reference;395
27;Glossary;402
28;Selected T-SQL and .NET Code Listings;414
28.1;Chapter 1;414
28.2;Chapter 2;415
28.3;Chapter 3;422
28.4;Chapter 4;428
28.5;Chapter 5;433
28.6;Chapter 6;437
28.7;Chapter 7;438
28.8;Chapter 8;440
28.9;Chapter 9;445
28.10;Chapter 10;448
28.11;Chapter 11;451
28.12;Chapter 12;452
29;Index;459