SQL Server 2000 Stored Procedures Handbook (Experts Voice)
SQL Server 2000 Stored Procedures Handbook (Experts Voice)
ISBN: 1590592875
EAN: 2147483647
EAN: 2147483647
Year: 2005
Pages: 100
Pages: 100
- 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
- Index_F
- Index_G
- Index_H
- Index_I
- Index_K
- Index_L
- Index_M
- Index_N
- Index_O
- Index_P
- Index_Q
- Index_R
- Index_S
- Index_T
- Index_U
- Index_V
- Index_W
- Index_X-Z
- List of Figures
- List of Examples
SQL Server 2000 Stored Procedures Handbook (Experts Voice)
ISBN: 1590592875
EAN: 2147483647
EAN: 2147483647
Year: 2005
Pages: 100
Pages: 100