文档介绍：Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The
By Ken Henderson
Publisher : Addison Wesley
Pub Date : December 28, 2001
ISBN : 0-201-70046-8
Table of
•
Contents Pages : 800
• Examples Slots : 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