Addison-Wesley The Guru#39;s Guide to SQL Server Stored Procedures.pdf
文本预览下载声明
Gurus 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
显示全部