SQL Server 2000 
Stored Procedure and XML 
Programming, Second Edition                 

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 development environment. SQL Server 2000 Stored Procedure & XML Programming teaches you to manage SQL Server resources using Enterprise Manager, Query Analyzer, SQL Profiler, Visual SourceSafe, Visual Basic and Visual Studio .NET.

Learn today's and tomorrow's 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.

• Build user-defined, system, temporary, global temporary, extended, remote, and nested stored procedures

•  Write code to interact with COM object, DTS packages, executables, mail, the Registry, jobs, full-text indexes and security

• Learn the finer points of using identity, timestamp, dynamically constructed queries, temporary tables, table variables, indexed views, distributed partitioned views, federated servers, user-defined functions, table-valued functions, instead-of triggers and more

• Create fast and scalable search Web pages

• Manage source code and deploy databases using traditional T-SQL scripts and alternatively Visual Studio .NET tools

• Master latest features of XML for SQL Web Releases: XML BulkLoad, UpdateGrams, DiffGrams, SOAP, Web Services, XML Views, OPENXML

• Access and modify databases though URL, POST, XML template, XPath queries, mapped XML schemas, Web Services

• Develop .NET applications for SQL Server 2000 databases using SQLXML managed classes

• Sample database, scripts,  .NET projects, XML templates, development and deployment tools available on www.TrigonBlue.com\SQLXML