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
Project Management JumpStart
Breaking Down the Project Activities
Planning and Acquiring Resources
Assessing Risk
Budgeting 101
Appendix B Sample Project Management Forms
SQL Tips & Techniques (Miscellaneous)
Using SQL Data Manipulation Language (DML) to Insert and Manipulate Data Within SQL Tables
Working with Functions, Parameters, and Data Types
Working with Comparison Predicates and Grouped Queries
Understanding SQL Subqueries
Working with Ms-sql Server Information Schema View
Building Web Applications with UML (2nd Edition)
Beyond HTTP and HTML
Modeling Secure Systems
Vision
Overview
Logical View
Pocket Guide to the National Electrical Code(R), 2005 Edition (8th Edition)
Article 90 Introduction
Article 320 Armored Cable Type AC
Article 388 Surface Nonmetallic Raceways
Article 409: Industrial Control Panels
Notes for Tables 11(A) and 11(B)
Microsoft Office Visio 2007 Step by Step (Step By Step (Microsoft))
Moving, Sizing, Rotating, and Copying Shapes
Inserting Pictures into Diagrams
Formatting Shapes and Diagrams
Applying Themes to Entire Diagrams
Storing Information with Network Shapes
Digital Character Animation 3 (No. 3)
Mesh Deformation
The Language of Movement
Posing the Body Naturally
Animating Walks
Reptiles
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