文档介绍：for RuBoard
Guru's Guide to SQL Server™ Stored Procedures,
XML, and HTML, The
ByKen Henderson
Publisher : Addison Wesley
Pub Date : December 28, 2001
ISBN : 0-201-70046-8
Pages : 800
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
for RuBoard
The dt Procedures
Best Practices
Version Control from Query Analyzer
Automating Script Generation with Version Control
Summary
Guru's Chapter Guide 5. Databaseto SQL Design Server™ Stored Procedures,
XML, andGeneral HTML, Approach The
By Ken HendersonModeling Tools
The Sample Project
Publisher The: Addison Five Processes Wesley
Pub Date The: December Five Phases 28, Examined 2001
ISBN Modeling: 0-201-70046-8 Business Processes
Pages Entity-Relationship: 800 Modeling
Slots Relational: 1 Data Modeling
Summary
Chapter 6. Data Volumes
Copyright
Approaches to Generating Data
Foreword
Speed
Preface
Summary
Introduction
About the Sample Databases
Acknowledgments
Part II: Objects
About the Author
Chapter 7. Error Handling
Error Reporting
Part I: The Basics
Handling Errors
Chapter 1. Stored Procedure Primer
Summary
What Is a Stored Procedure?
Stored Procedure Advantages
Chapter 8. Triggers
Creating a Stored Procedure
Determining What Has Changed
Altering Stored Pr