The Guru's Guide to SQL Server Stored Procedures, XML, and HTML

Ken Henderson

Addison-Wesley Professional, 2002 - Computers - 774 pages

SQL Server developers worldwide raved about Ken Henderson's The Guru's Guide to Transact-SQL: its exceptionally clear, conversational explanations, and its powerfully useful projects and code examples. This book helps SQL Server developers take the next step -- building more powerful, robust applications than ever before. Henderson identifies several key areas of SQL Server development that offer the greatest power -- and then covers each of them in exceptional detail. The book includes especially thorough coverage of Transact-SQL stored procedure programming, including features such as extended procedures, database design, and XML that are often disregarded in competitive books. Henderson introduces a method he has developed to add arrays to T-SQL, something previously thought impossible. He offers an ideal balance of theory and code, gradually building on basic techniques to create increasingly sophisticated solutions, and teaching the philosophy of Transact-SQL programming alongside syntax and technique. An accompanying CD-ROM includes extensive source code, including valuable proprietary code that makes T-SQL queries run faster. For every SQL Server developer.

Contents

• Stored Procedure Primer: 3
• Suggested Conventions: 49
• Common Design Patterns: 73
• Source Code Management: 103
• Automating Script Generation with Version Control: 115
• Database Design: 121
• Chapter 6: 183
• PART IIOBJECTS: 199
• Triggers: 215
• Views: 245
• UserDefined Functions: 291
• PART IIIHTML XML AND NET: 337
• Introduction to XML: 353
• HTTP Queries: 381
• Retrieving Data: 401
• OPENXML: 421
• NET and the Coming Revolution: 459
• PART IVADVANCED TOPICS: 477
• Debugging and Profiling: 513
• Automation: 529
• Extended Stored Procedures: 555
• Administrative Stored Procedures: 585
• Undocumented TransactSQL: 627
• Arrays: 675
• PART VESSAYS ON SOFTWARE ENGINEERING: 701
• Evolutionary Development: 711
• The Gestalt of Testing: 733
• Testing in the Extreme: 740

About the author

Ken Henderson, a nationally recognized consultant and leading DBMS practitioner, consults on high-end client/server projects for such customers as the U.S. Air Force, the U.S. Navy, H&R Block, Travelers Insurance, J.P. Morgan, the CIA, Owens-Corning, and CNA Insurance. He is the author of five previous books on client/server and DBMS development, a frequent magazine contributor to such publications as Software Development Magazine and DBMS Magazine, and a speaker at technical conferences. 0201700468AB07032003

Bibliographic information

• Title: The Guru's Guide to SQL Server Stored Procedures, XML, and HTML
• Author: Ken Henderson
• Edition: illustrated, reprint
• Publisher: Addison-Wesley Professional, 2002
• ISBN: 0201700468, 9780201700466
• Length: 774 pages
• Subjects: Computers / Database Administration & Management; Computers / Languages / HTML; Computers / Languages / SQL; Computers / Languages / XML