ISBN 9788126507320,Professional Sql Server 2005 Xml

Professional Sql Server 2005 Xml


Scott Klein



Wiley India Pvt Ltd

Publication Year 2006

ISBN 9788126507320

ISBN-10 8126507322


Number of Pages 526 Pages
Language (English)

Computer programming

Professional SQL Server 2005 XML focuses on using the new and advanced SQL Server 2005 XML features to get the most out of SQL Server 2005 and XML. The book makes extensive use of examples to solve solutions that programmers face on an everyday basis. After a brief introduction to the new SQL Server 2005 XML features, to get all readers onto an equal prerequisite footing, the book dives into the following main topics: A brief discussion on how Schema apply to SQL Server XML Deep discussion on SQL Server 2005 XML (both from the server and client side) using XSLT to render the XML Data that is retrieved from SQL Server, particularly for ASP.NET SQL Server and Soap (this is important because a lot of the web services technology (soap, etc) is now built into SQL Server 2005 SQL Server and XML Security SQL Server and .Net SQL Server 2005 XML best practices Putting our new found knowledge to work with a case study Special Feature Wrox! First book on SQL Server 2005 and XML application development XML is important for SQL Server developers displaying data on the web or exchanging data between SQL Server and other applications and databases XML support in SQL Server is one of the major SQL Server 2005 upgrades and one that will get the lion's share of technical marketing from Microsoft to developers SQL Server 2005 XML could be the hot SQL Server 2005 topic like Reporting Services was for SQL Server 2000. About the Author Scott Klein is a Senior Architect with CSI (Computer Software Innovations). His recent projects include migrating a Visual FoxPro accounting application to SQL Server 2000/2005 and .NET. Prior to that he Senior Systems Engineer and Senior Developer positions with Citrix and and included creating XML, ASP.NET, and SQL Server applications. He holds the MCDBA certification for SQL Server 2000 and has 15 years SQL Server experience along with 5 years working with XML. Scott has written extensively online for sites including Table of Contents Introduction Part I: Introduction to SQL Server 2005 XML o What's New in Version 2.0 of the .NET Framework for XML o What's New in SQL Server 2005 XML o Installing SQL Server 2005 Part II: Server-Side XML Processing in SQL Server 2005 o XML data type o Querying and Modifying XML Data in SQL Server 2005 o Indexing XML Data in SQL Server 2005 o XML Schemas in SQL Server 2005 o Transact-SQL Enhancements to FOR XML and OPENXML o CLR Support in SQL Server 2005 Part III: Client-Side XML Processing in SQL Server 2005 o Client-Side Support for the xml data type o Client-Side XML Processing with SQLXML 4.0 o Creating and Querying XML Views o Updating the XML View Using Updategrams o Bulk Loading XML Data Through the XML View o SQLXML Data Access Methods o Using XSLT in SQL Server 2005 Part IV: SQL Server 2005, SqlXml, and SOAP. o Web Service (SOAP) Support in SQL Server 2005 o SOAP at the Client o Web Service Description Language (WSDL) Part V: SQL Server 2005 and Visual Studio 2005 o SQL Server 2005 SQLXML Managed Classes o Working with Assemblies o Creating .NET Routines o ADO.NET o ADO.NET 2.0 Guidelines and Best Practices o Case Study - Putting It All Together o Appendix A: XQuery in SQL Server 2005 o Index