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

文档介绍：Online Help
Table Of Contents
1. Table of Content 8
2. Starting Page 16
3. Copyright 17
4. Foreword 19
5. Preface 21
6. Introduction 26
About the Sample Databases 28
Acknowledgments 29
About the Author 29
7. Part I: The Basics 30
Chapter 1. Stored Procedure Primer 30
What Is a Stored Procedure? 31
Stored Procedure Advantages 32
Creating a Stored Procedure 32
Altering Stored Procedures 45
Executing Stored Procedures 46
Extended Stored Procedures 60
Environmental Issues 62
Parameters 65
Flow Control Language 70
Errors 72
Nesting 73
Recursion 74
Summary 75
Chapter 2. Suggested Conventions 75
Source Formatting 76
Coding Conventions 90
Summary 98
Chapter 3. Common Design Patterns 99
The Law of Parsimony 100
Idioms 101
Design Patterns 110
Summary 129
Chapter 4. Source Code Management 129
The Benefits of Source Code Management 130
The dt Procedures 132
Best Practices 133
Version Control from Query Analyzer 140
Automating Script Generation with Version Control 142
Summary 146
Chapter 5. Database Design 146
General Approach 147
Modeling Tools 147
The Sample Project 148
The Five Processes 148
The Five Phases Examined 150
Modeling Business Processes 157
Entity-Relationship Modeling 170
Relational Data Modeling 190
Summary 208
Chapter 6. Data Volumes 208
Approaches to Generating Data 209
Speed 223
Summary 224
8. Part II: Objects 224
Chapter 7. Error Handling 225
Error Reporting 225
Handling Errors 227
Summary 238
Chapter 8. Triggers 239
Determining What Has Changed 240
Managing Sequential Values 246
Trigger Restrictions 248
INSTEAD OF Triggers 250
Triggers and Auditing 253
Transactions 25