SQL Server 2000 Stored Procedure & XML Programming, Second 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. Table of contents 1: Introduction 2: The SQL Server Environment 3: Stored Procedure Design Concepts 4: Basic Transact-SQL Programming Constructs 5: Functions 6: Composite Transact-SQL Constructs: Batches, Scripts, and Transactions 7: Debugging and Error Handling 8: Special Types of Procedures 9: Advanced Stored Procedure Programming 10: Interaction with the SQL Server Environment 11: Source Code Management and Database Deployment 12: Stored Procedures for Web Search Engines 13: Introduction to XML for Database Developers 14: Publishing Information Using SQLXML 15: Modifying Databases Using SQLXML Appendix: T-SQL and XML Data Types in SQL Server 2000