The Guru[ap]s Guide to SQL Server[tm] Stored Procedures, XML, and HTML
![The Guru[ap]s Guide to SQL Server[tm] Stored Procedures, XML, and HTML](/icons/blank_book.jpg "The Guru[ap]s Guide to SQL Server[tm] Stored Procedures, XML, and HTML"){kind=icon}
The Guru[ap]s Guide to SQL Server[tm] Stored Procedures, XML, and HTML
ISBN: 201700468
EAN: N/A
EAN: N/A
Year: 2005
Pages: 223
Pages: 223
- Table of Content
- Starting Page
- 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
- SELECTFOR 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 Pice de Rsistance
- 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
- 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
The Guru[ap]s Guide to SQL Server[tm] Stored Procedures, XML, and HTML
ISBN: 201700468
EAN: N/A
EAN: N/A
Year: 2005
Pages: 223
Pages: 223
- ERP Systems Impact on Organizations
- Challenging the Unpredictable: Changeable Order Management Systems
- Enterprise Application Integration: New Solutions for a Solved Problem or a Challenging Research Field?
- Distributed Data Warehouse for Geo-spatial Services
- Healthcare Information: From Administrative to Practice Databases