SQL Server 2000 Stored Procedure & XML Programming 2/e
Dejan Sunderic

ISBN: 0072228962,
Division: Professional,
Price: £36.99,
Pub Date: JUN-03,

Pages: 696
Edition: 01
Format: Paperback

Availability: In Stock

Description

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.
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.
    • Author Biography

  • Dejan Sunderic
    Dejan Sunderic (Toronto, Ontario) MCSD is the Principal Consultant at Sage Information Consultants, Inc., a consulting company based in Toronto specializing in development and infrastructure solutions.

    		•
    Table of Contents

    Ch. 1: Introduction
    Ch. 2: Relational Database Concepts and the SQL Server Environment
    Ch. 3: Stored Procedure Design Concepts
    Ch. 4: Basic Transact-SQL Programming Constructs
    Ch. 5: Functions
    Ch. 6: Composite Transact-SQL Constructs?Batches, Scripts, and Transactions
    Ch. 7: Debugging and Error Handling
    Ch. 8: Developing Professional Habits
    Ch. 9: Special Types of Stored Procedures
    Ch. 10: Advanced Stored Procedure Programming
    Ch. 11: Interaction with the SQL Server Environment
    Ch. 12: Stored Procedure for Web Search Engine
    Ch. 13: Introduction to XML for DBAs
    Ch. 14: Publishing Database Information Using XML
    Ch. 15: Modifying Databases Using XML



    Website: www.mcgraw-hill.co.uk Tel: +44 (0) 1628 502500