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
High-Speed Signal Propagation[c] Advanced Black Magic
Intercabinet Applications
UTP Noise and Interference
Power Supply Filtering for Clock Sources, Repeaters, and PLL Circuits
Controlling Crosstalk on Clock Lines
Appendix B. Calculation of Loss Slope
Cisco IOS in a Nutshell (In a Nutshell (OReilly))
Pausing Output
Reverse Telnet
Networking Technologies
VoIP
IGRP
The Complete Cisco VPN Configuration Guide
IPsec Connections
ISAKMP/IKE Phase 1 Policies
ISAKMP/IKE Phase 1 Management Connection
Troubleshooting PIX and ASA Connections
Summary
Lotus Notes Developers Toolbox: Tips for Rapid and Successful Deployment
The Object Pane
Working with Framesets
Working with Dates
Refresh a Document from the User Interface
Generate a New Document by Duplicating an Existing Document
Professional Struts Applications: Building Web Sites with Struts ObjectRelational Bridge, Lucene, and Velocity (Experts Voice)
The Challenges of Web Application Development
Creating a Struts-based MVC Application
Building a Data Access Tier with ObjectRelationalBridge
Templates and Velocity
Building the JavaEdge Application with Ant and Anthill
Java All-In-One Desk Reference For Dummies
Book III - Object-Oriented Programming
Choosing from a List
Creating Applets
Creating Servlets
Using Java Server Pages
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