Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL and .NET

Dejan Sunderic

664 pages, parution le 01/06/2006

Ajouter à une liste

Indisponible

Résumé

Essential for developers and database administrators who use SQL Server 2005 on a daily basis, this guide explains how to take full advantage of stored procedures: operations that are stored with the database server, allowing access to all clients.The book covers the design of stored procedures in both T-SQL and CLR languages such as C# and Visual Basic .NET and readers will learn to develop programmable database objects and scalable Web-based applications.

Includes sample code and templates
Explains how to develop stored procedures that interact with external systems
Covers debugging and security

L'auteur - Dejan Sunderic

Dejan Sunderic, MCDBA, is the principal consultant at Trigon Blue, Inc., and the president of the Toronto SQL Server User Group. He specializes in database and application development on the SQL Server platform.

Sommaire

The SQL Server 2005 Environment and Tools
Stored Procedure Design Concepts
Basic Transact-SQL Programming Constructs
Functions
Composite Transact-SQL Constructs: Batches, Scripts, and Transactions
Error Handling
Special Types of Stored Procedures
Views
Triggers
User-defined Functions
Fundamentals of .NET Programming in SQL Server 2005
Fundamentals of CLR Stored Procedure Development
CLR Functions and Triggers
CLR Database Objects Advanced Topics
Advanced Stored Procedure Programming
Debugging
Source Code Management
Database Deployment
Security
Stored Procedures for Web Search Engines
Interaction with the SQL Server Environment

Appendix A: Naming Conventions
Appendix B: Stored Procedure Compilation, Storage, and Reuse
Appendix C: DAta Types in SQL Server 2005

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Mc Graw Hill
Auteur(s)	Dejan Sunderic
Parution	01/06/2006
Nb. de pages	664
Format	18,5 x 23
Couverture	Broché
Poids	1140g
Intérieur	Noir et Blanc
EAN13	9780072262285
ISBN13	978-0-07-226228-5