---

SQL Server 2000 Stored Procedures Handbook (Experts Voice)

ISBN: 1590592875
EAN: 2147483647

Year: 2005
Pages: 100

Authors: Robin Dewson, Louis Davidson, Tony Bain, Chuck Hawkins, Tony Bain, Louise Davidson, Robin Dewson, Chuck Hawkins

BUY ON AMAZON

• 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