Skip to main content

Professional SQL ServerTM 2005 XML

Professional SQL ServerTM 2005 XML

Scott Klein

ISBN: 978-0-764-59792-3

Jan 2006

552 pages

Select type: Paperback

Product not available for purchase

Description

  • Discusses SQL Server 2005 XML from the server and client sides
  • Examines using XSLT to render the XML data that is retrieved from SQL Server, particularly for ASP.NET
  • Addresses SQL Server relationship with schemas, SOAP, XML security, and .NET
  • Makes extensive use of examples to solve problems that programmers face on an everyday basis and features Server 2005 XML best practices
Introduction.

Part I: Introduction to SQL Server 2005 XML.

Chapter 1: What’s New in Version 2.0 of the .NET Framework for XML.

Chapter 2: What’s New in SQL Server 2005 XML.

Chapter 3: Installing SQL Server 2005.

Part II: Server-Side XML Processing in SQL Server 2005.

Chapter 4: xml data type.

Chapter 5: Querying and Modifying XML Data in SQL Server 2005.

Chapter 6: Indexing XML Data in SQL Server 2005.

Chapter 7: XML Schemas in SQL Server 2005.

Chapter 8: Transact-SQL Enhancements to FOR XML and OPENXML.

Chapter 9: CLR Support in SQL Server 2005.

Part III: Client-Side XML Processing in SQL Server 2005.

Chapter 10: Client-Side Support for the xml data type.

Chapter 11: Client-Side XML Processing with SQLXML 4.0.

Chapter 12: Creating and Querying XML Views.

Chapter 13: Updating the XML View Using Updategrams.

Chapter 14: Bulk Loading XML Data Through the XML View.

Chapter 15: SQLXML Data Access Methods.

Chapter 16: Using XSLT in SQL Server 2005.

Part IV: SQL Server 2005, SqlXml, and SOAP.

Chapter 17: Web Service (SOAP) Support in SQL Server 2005.

Chapter 18: SOAP at the Client.

Chapter 19: Web Service Description Language (WSDL).

Part V: SQL Server 2005 and Visual Studio 2005.

Chapter 20: SQL Server 2005 SQLXML Managed Classes.

Chapter 21: Working with Assemblies.

Chapter 22: Creating .NET Routines.

Chapter 23: ADO.NET.

Chapter 24: ADO.NET 2.0 Guidelines and Best Practices.

Chapter 25: Case Study — Putting It All Together.

Appendix A: XQuery in SQL Server 2005.

Index.

Downloadable Code
Code Downloads
Code downloads for this title are available here.
Downloadable Code
Download
Code Downloads
Code downloads for this title are available here.
Download
ChapterPageDetailsDatePrint Run
Download (Code Replacement)
The content for this title has been posted and may be accessed via http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764597922.html
3/22/06

9Error in Code
code at bottom of page, lines 3 and 4:
Xpen.MoveToFirstChild()
Xpen.MoveToNext()

should be:
xpn.MoveToFirstChild()
xpn.MoveToNext()
8/17/06

58Error in Text
first line:
sys.sys. schemas

should be:
sys.schemas
6/26/06

97Error in Text
first and 2nd paragraphs below the XQuery Sorting heading:
1st paragraph, line 1 (2 places) and line 2; 2nd pagraph line 1:
GROUP BY

should be:
ORDER BY
9/29/06