Flylib.com
SQL Server 2000 Stored Procedures Handbook (Experts Voice)
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
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
Metrics and Models in Software Quality Engineering (2nd Edition)
Software Quality
Fundamentals of Measurement Theory
Halsteads Software Science
Availability Metrics
Staged versus Continuous Debating Religion
Postfix: The Definitive Guide
Postfix Origins and Philosophy
Additional Information and How to Obtain Postfix
How qmgr Works
Local Delivery and POP/IMAP
C.4. Installation
Logistics and Retail Management: Emerging Issues and New Challenges in the Retail Supply Chain
Relationships in the Supply Chain
Temperature-Controlled Supply Chains
Rethinking Efficient Replenishment in the Grocery Sector
Transforming Technologies: Retail Exchanges and RFID
Enterprise Resource Planning (ERP) Systems: Issues in Implementation
Information Dashboard Design: The Effective Visual Communication of Data
Choosing a Deficient Measure
Tapping into the Power of Visual Perception
Applying the Principles of Visual Perception to Dashboard Design
Designing Dashboards for Usability
Maintain Consistency for Quick and Accurate Interpretation
File System Forensic Analysis
Overview of Toolkits
Volume Analysis
Bibliography
Other Topics
UFS2 Superblock
Understanding Digital Signal Processing (2nd Edition)
DFT SCALLOPING LOSS
BANDPASS QUADRATURE SIGNALS IN THE FREQUENCY DOMAIN
INTERPOLATION
ZERO-PHASE FILTERING
COMPUTING FFT TWIDDLE FACTORS
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies