The Microsoft Transact-SQL programming language has become an increasingly popular solution for developers seeking to build powerful and scalable distributed SQL Server applications. This follow-up to the widely acclaimed The Guru's Guide to Transact-SQL covers current subjects critical to successful SQL Server application development in depth, while leading developers to new heights in their overall programming skills.Blending theoretical detail with practical application, this comprehensive reference begins by providing a foundational overview of SQL Server stored procedure programming. From there, the book moves on to best practices and design considerations before progressing to advanced topics - providing the most complete coverage of SQL Server stored procedure programming available in one source. Topics such as extended procedures, OLE Automation, database design, and XML are covered in detail, while the book spotlights undocumented language features and brings the first application of design patterns to SQL. The preview of.NET and a groundbreaking way to add arrays to Transact-SQL make for the most thorough and engaging read published to date on SQL Server programming.The Guru's Guide to SQL Server Stored Procedures, XML, and HTML includes sample projects with complete source code suitable for plugging into real world applications. Additional highlights include:End-to-end coverage of stored procedure construction, best practices, and common conventions.In-depth coverage of "procedural" objects, including triggers, views, and user-defined functions.A comprehensive discussion of employing HTML and XML in SQL Server applications, as well as an introduction to Microsoft's new .NET platform.Expert advice on debugging and profiling stored procedure code.Step-by-step instructions on how to create advanced stored procedure objects including extended stored procedures and administrative procedures.A behind-the-scenes look at undocumented Transact-SQL elements and coding tricks.Software engineering essays addressing the work environment, evolutionary code development, and software testing.An accompanying CD-ROM contains the book's source code along with several handy database administration tools. More than 600 code files, programming utilities, extended procedures, and SQL scripts demonstrate the real power of SQL Server programming and provide a tremendous value to the reader.Both comprehensive and practical, The Guru's Guide to SQL Server Stored Procedures, XML, and HTML provides developers with a complete tool set for becoming expert stored procedure programmers and better software practitioners.