Writing Stored Procedures for Microsoft SQL Server

Shepker

346 pages, parution le 30/06/2000

Ajouter à une liste

Indisponible

Résumé

Writing Stored Procedures for Microsoft SQL Server focuses on teaching you not only how to build effective stored procedures, but also how to optimize and streamline them for long term use. Get an understanding of how SQL Server interprets stored procedures verses direct access via SQL queries. This is followed by detailed instructions on creating and maintaining a repository of stored procedures. Once you know how stored procedures are created and built, you are taught how to determine which logic within an application makes sense to be put into this scheme.

Additionally, you're provided with guidance on making stored procedures that are portable across applications.

The first book from Macmillan to focus on stored procedures
Stored procedures are the primary interaction that developers have with a database and can be used by any SQL Server programmer.

Matt Shepker is a Microsoft Certified Trainer and a SQL Server consultant.

Contents

Introduction 1

PART I - Introduction to Developing Stored Procedures
- 1 SQL Server and Stored Procedure Background 7
- 2 Stored Procedure Camps 17
- 3 Processing Stored Procedures 31
- 4 Stored Procedures Rules 47
PART II - Simple Stored Procedures
- 5 Creating and Altering Stored Procedures 63
- 6 Creating More Complex Stored Procedures 93
- 7 Creating Stored Procedures that Insert Data 115
- 8 Creating Stored Procedures that Modify Data 135
PART III - Security and Advanced Procedure Development
- 9 Providing Security for Stored Procedures 159
- 10 Programming Structures in SQL 179
- 11 Writing Utility Stored Procedures 201
- 12 Extended Stored Procedures 243
- 13 Creating Custom Functions 257
PART IV - XML and Triggers
- 14 SQL Server XML Support 273
- 15 Writing Triggers 297
- 16 Considerations When Using Stored Procedures and Triggers 317
Index 333

Caractéristiques techniques

	PAPIER
Éditeur(s)	Sams
Auteur(s)	Shepker
Parution	30/06/2000
Nb. de pages	346
Format	18,7 x 23,2
Couverture	Broché
Poids	616g
Intérieur	Noir et Blanc
EAN13	9780672318863