Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, TheBy Ken Henderson Publisher: Addison WesleyPub Date: December 28, 2001ISBN: 0-201-70046-8Pages: 800Slots: 1 Copyright Foreword Preface Introduction About the Sample Databases Acknowledgments About the Author Part I: The Basics Chapter 1. Stored Procedure Primer What Is a Stored Procedure? Stored Procedure Advantages Creating a Stored Procedure Altering Stored Procedures Executing Stored Procedures Extended Stored Procedures Environmental Issues Parameters Flow Control Language Errors Nesting Recursion Summary Chapter 2. Suggested Conventions Source Formatting Coding Conventions Summary Chapter 3. Common Design Patterns The Law of Parsimony Idioms Design Patterns Summary Chapter 4. Source Code Management The Benefits of Source Code Management The dt Procedures Best Practices Version Control from Query Analyzer Automating Script Generation with Version Control Summary Chapter 5. Database Design General Approach Modeling Tools The Sample Project The Five Processes The Five Phases Examined Modeling Business Processes Entity-Relationship Modeling Relational Data Modeling Summary Chapter 6. Data Volumes Approaches to Generating Data Speed Summary Part II: Objects Chapter 7. Error Handling Error Reporting Handling Errors Summary Chapter 8. Triggers Determining What Has Changed Managing Sequential Values Trigger Restrictions INSTEAD OF Triggers Triggers and Auditing Transactions Execution Calling Stored Procedures Nested Triggers Disabling Triggers Best Practices Summary Chapter 9. Views Meta-data Restrictions ANSI SQL Schema Views Updatable Views The WITH CHECK OPTION Clause Derived Tables Parameterized Views Dynamic Views Partitioned Views Indexed Views Designing Modular Indexed Views Summary Chapter 10. User-Defined Functions Scalar Functions Table-Valued Functions Inline Functions Limitations Meta-data Creating Your Own System Functions UDF Cookbook Summary Part III: HTML, XML, and NET Chapter 11. HTML Origins Producing HTML from Transact-SQL Producing HTML from sp_makewebtask Summary Chapter 12. Introduction to XML Wooden Nickels XML: An Overview HTML: Simplicity Comes at a Price XML: A Brief History XML versus HTML: An Example Document Type Definitions XML Schemas Extensible Stylesheet Language Transformation (XSLT) Document Object Model Further Reading Tools Summary Chapter 13. XML and SQL Server: HTTP Queries Accessing SQL Server over HTTP URL Queries Template Queries Summary Chapter 14. XML and SQL Server: Retrieving Data SELECT…FOR XML RAW Mode AUTO Mode ELEMENTS EXPLICIT Mode Mapping Schemas Summary Chapter 15. XML and SQL Server: OPENXML The Flags Parameter Edge Table Format Inserting Data with OPENXML() Web Release 1 Limitations Summary Chapter 16. .NET and the Coming Revolution .NET: The Future of Applications Development What Is .NET? On Microsoft Bashing Microsoft Bigotry? Summary Part IV: Advanced Topics Chapter 17. Performance Considerations Indexing Statistics Query Optimization Summary Chapter 18. Debugging and Profiling Debugging Profiling Stress Testing Summary Chapter 19. Automation A Brief Overview of COM SQL Server and COM Automation Summary Chapter 20. Extended Stored Procedures Open Data Services A Simple Example A Better Example Making Extended Procedures Easier to Use Debugging Extended Procedures Isolating Extended Procedures xp_setpriority Summary Chapter 21. Administrative Stored Procedures sp_readtextfile sp_diff sp_generate_script Sp_start_trace sp_stop_trace sp_list_trace sp_proc_runner sp_create_backup_job sp_diffdb Summary Chapter 22. Undocumented Transact-SQL What Defines Undocumented? Undocumented Procedures Creating INFORMATION_SCHEMA Views Creating System Functions Undocumented DBCC Commands Undocumented Trace Flags Summary Chapter 23. Arrays xp_array.dll Array System Functions The Pièce de Résistance Multidimensional Arrays Summary Part V: Essays on Software Engineering Chapter 24. Creating a Workable Environment Get Rid of Distractions Close the Door Internal Distractions Form Over Function Silence Is Golden; Communication Divine Conclusion Epilogue Chapter 25. Evolutionary Development Kaizen The Benefits of Small Changes Software Software Entropy Refactoring Selling Management (or Yourself) on Refactoring When Not to Refactor Databases Can You Refactor Instead of Design? Code Extinction Extreme Programming Conclusion Epilogue Chapter 26. The Gestalt of Testing Where to Begin The Futility of Testing Types of Tests When to Test Testing Can Save Time Testing in the Extreme Other Types of Testing Conclusion Epilogue References