SQL Server 2000 Stored Procedures Handbook (Experts Voice) - page 1
- 1
- 2
- Table of Contents
- Table of Contents
- BackCover
- SQL Server 2000 Stored Procedures Handbook
- Introduction
- Book Outline
- Chapter 1: Stored Procedures Overview
- What is a Stored Procedure?
- Creating Stored Procedures
- Why Use Stored Procedures?
- Replication
- Designing Good Stored Procedures
- Data integrity
- Calling a Stored Procedure
- Rules for Stored Procedures
- Modifying Stored Procedures
- Parameter Usage
- Flow control
- Nesting in Stored Procedures
- Returning Values
- Restoring the Example Databases to their Default Condition
- Summary
- Chapter 2: Optimizing and Debugging
- The Execution Plan
- Common Mistakes
- Error Handling
- SQL Server Debugger
- Summary
- Chapter 3: Concurrency, Cursors, and Transactions
- Cursors
- Transactions
- Concurrency
- Summary
- Chapter 4: Common Practices with Stored Procedures
- Typical Purposes
- Points to Avoid While Using Stored Procedures
- Summary
- Chapter 5: System Stored Procedures
- System Stored Procedures
- Undocumented Functionality
- Performing Complex Tasks with System Stored Procedures
- Tracing Object Creation and Deletion
- SQL Mail
- Summary
- Chapter 6: User Defined Functions
- UDFs
- Creating a UDF
- Scalar Valued Functions
- TABLE Data Type
- Schema Binding
- Stored Procedures versus UDFs
- Summary
- Chapter 7: Triggers
- What is a Trigger?
- Why use Triggers?
- Performance
- Creating and using a trigger
- Types of Trigger
- Transactions and Triggers
- Trigger versus Constraints
- Triggers versus Stored Procedure
- Replication
- Recursion
- Good Practice
- Bad Practice
- Summary
- Chapter 8: Security
- SQL Server Vulnerabilities
- Encrypting Stored Procedures
- Summary
- Appendix A: Support, Errata, and http:forums.apress.com
- Errata
- The Peer-to-Peer Forums at http:forums.apress.com
- Customer Support and Feedback
- Index
- Index_A
- Index_B
- Index_C
- Index_D
- Index_E
- 1
- 2
