|
SQL Server 2000 Stored Procedures & XML Programming 2nd Edition
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.
FEATURES:
*
*Revised and expanded to cover the most recent technology to be infused into SQL Server 2000'most notably extended XML capabilities and updates due to the release of VS.NET.
* *Readers start by getting a sound conceptual grounding on stored procedures and learn how to practically apply what they've learned to harness their full benefits:
* *Modular programming
* *Faster execution
* *Reduction of network traffic
* *Use as a security mechanism
* *Sample database for download that will be used in examples throughout the book.
* *A key feature for the revision is a new chapter with an end-to-end solution for a Web search engine developed by the author.
CONTENTS:
Introduction
The SQL server environment
Stored procedure design concepts
Basic transact-SQL constructs
Debugging
Special types of procedues
Advanced stored procedure programming
Interaction
Source code management
Web search engines
XML for database developers
SQLXML
|