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
Adobe After Effects 7.0 Studio Techniques
Workspaces and Panels
Organization
Animation Methods
Articulated Mattes
Expressions
Cisco ASA: All-in-One Firewall, IPS, and VPN Adaptive Security Appliance
Virtual Private Networks
Managing Licenses
IP Version 6
Computer Telephony Interface Quick Buffer Encoding Inspection
Architectural Overview
Sap Bw: a Step By Step Guide for Bw 2.0
Generic R/3 Data Extraction
Maintaining InfoCube Data
Tuning Query Performance
System Landscape
Appendix B. SAP Basis Overview
802.11 Wireless Networks: The Definitive Guide, Second Edition
11 Nomenclature and Design
The Temporal Key Integrity Protocol (TKIP)
Gaussian Frequency Shift Keying (GFSK)
11a and 802.11j: 5-GHz OFDM PHY
A Peek Ahead at 802.11n: MIMO-OFDM
What is Lean Six Sigma
The Four Keys to Lean Six Sigma
Key #1: Delight Your Customers with Speed and Quality
Key #2: Improve Your Processes
Key #3: Work Together for Maximum Gain
Six Things Managers Must Do: How to Support Lean Six Sigma
Quantitative Methods in Project Management
Project Value: The Source of all Quantitative Measures
Introduction to Probability and Statistics for Projects
Organizing and Estimating the Work
Making Quantitative Decisions
Special Topics in Quantitative Management
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