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
Absolute Beginner[ap]s Guide to Project Management
Trends in Project Management
Building a Project Plan
Essential Elements of a Project Change Control System
Best Practices
Keys to Better Project Team Performance
Inside Network Security Assessment: Guarding Your IT Infrastructure
What Security Is and Isnt
Post-Assessment Activities
Security Tool Websites
Analysis
Conclusions
The New Solution Selling: The Revolutionary Sales Process That Is Changing the Way People Sell [NEW SOLUTION SELLING 2/E]
Chapter One Solutions
Chapter Five Stimulating Interest
Chapter Eight Creating Visions Biased to Your Solution
Chapter Eleven Gaining Access to People with Power
Appendix B Solution Selling: A Scalable Approach
Programming Microsoft ASP.NET 3.5
Paging Through Data Sources
ASP.NET Mobile Controls
ASP.NET State Management
ASP.NET Security
Data-Bound and Templated Controls
Persuasive Technology: Using Computers to Change What We Think and Do (Interactive Technologies)
Overview of Captology
The Functional Triad Computers in Persuasive Roles
Computers as Persuasive Tools
Computers as Persuasive Media Simulation
Computers as Persuasive Social Actors
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
The Working Directory
Extracting and Loading Data
Branching in SQL*Plus
SQL*Plus Settings You Can Control
Section A.2. Commands You Can Issue Within SQL*Plus
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