SQL Server 2000 Stored Procedure and XML Programming, Second...

Features

• Cover Type: Paperback with 696 pages
• Published by: McGraw-Hill Osborne Media
• Edition: 2nd Edition May 16, 2003
• Written in: English
• ISBN 10 Number: 0072228962
• ISBN 13 Number: 978-0072228960
• Book Dimensions: 9.1 x 7.2 x 1.5 inches
• Weighs: 2.5 pounds

Product Description
Get thorough coverage of SQL Server 2000—including extended XML capabilities and VS.NET updates with this expertly written resource. Learn to harness the full benefits of modular programming, and achieve faster execution and a reduction of network traffic. Included are a sample database and an end-to-end solution for a Web search engine.

Back Cover Copy


Design T-SQL and SQLXML Solutions

Discover the key concepts, techniques, tips, and tricks professional developers need to know in order to take full advantage of stored procedures in the SQL Server environment. SQL Server 2000 Stored Procedure & XML Programming, Second Edition teaches you to manage SQL Server resources using Enterprise Manager, Query Analyzer, SQL Profiler, Visual SourceSafe, Visual Basic, and Visual Studio .NET. Learn basic and advanced XML with special focus on features that are in use in Microsoft database and development tools. Develop dynamic, Web-based applications using SQL Server's XML capabilities. This helpful resource contains simple explanations for developers who are just starting to work with stored procedures and XML, as well as advanced recommendations and techniques for experienced developers.

Essential Skills for Database Professionals

• Build user-defined, system, temporary, global temporary, extended, remote, and nested stored procedures
• Write code to interact with COM objects, DTS packages, executables, mail, the Registry, jobs, full-text indexes, and security
• Manage source code and deploy databases using T-SQL scripts or Visual Studio .NET tools
• Learn the finer points of using identity, timestamp, dynamically constructed queries, temporary tables, and more
• Master the latest features of XML for SQL Web Releases--XML BulkLoad, UpdateGrams, DiffGrams, SOAP, Web Services, XML Views, and OPENXML
• Access and modify databases through URL, POST, XML template, XPath queries, mapped XML schemas, and Web Services
• Develop .NET applications for SQL Server 2000 databases using SQLXML managed classes
• Sample scripts, .NET projects, databases, XML templates, and development and deployment tools available online

Reader Reviews
I'm a developer with a degree in CS and ten years' experience. I bought this book for an SQL Server 2000 project, because I've got more experience with mysql which has slightly different syntax and doesn't support stored procedures. I guess I just assumed this book would contain query syntax reference. But it doesn't. It is very thorough on stored procedures and xml and I'm sure I will be glad I have it. But- If you don't already have one, you will still need to get a query syntax reference.