Sql Server 2000 Stored Procedure & Xml Programming

Dejan Sunderic

680 pages, parution le 13/06/2003

Ajouter à une liste

Indisponible

Résumé

Get thorough coverage of SQL Server 2000'including extended XML capabilities and VS.NET updates with this expertly written resource. Learn to harness the full benefits of modular programming, and achieve faster execution and a reduction of network traffic. Included are a sample database and an end-to-end solution for a Web search engine.

KEY FEATURES

Revised and expanded to cover the most recent technology to be infused into SQL Server 2000'most notably extended XML capabilities and updates due to the release of VS.NET.
Readers start by getting a sound conceptual grounding on stored procedures and learn how to practically apply what they've learned to harness their full benefits:
Modular programming
Faster execution
Reduction of network traffic
Use as a security mechanism
Sample database for download that will be used in examples throughout the book.
A key feature for the revision is a new chapter with an end-to-end solution for a Web search engine developed by the author.

Introduction
Relational Database Concepts and the SQL Server Environment
Stored Procedure Design Concepts
Basic Transact-SQL Programming Constructs
Functions
Composite Transact-SQL Constructs'Batches, Scripts, and Transactions
Debugging and Error Handling
Developing Professional Habits
Special Types of Stored Procedures
Advanced Stored Procedure Programming
Interaction with the SQL Server Environment
Stored Procedure for Web Search Engine
Introduction to XML for DBAs
Publishing Database Information Using XML
Modifying Databases Using XML

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.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Mc Graw Hill
Auteur(s)	Dejan Sunderic
Parution	13/06/2003
Nb. de pages	680
Format	19 x 23
Couverture	Broché
Poids	1140g
Intérieur	Noir et Blanc
EAN13	9780072228960
ISBN13	978-0-07-222896-0