SQL Server 2000 Stored Procedure & XML Programming, Second Edition [Paperback]

Dejan Sunderic (Author)

Book Description

ISBN-10: 0072228962 | ISBN-13: 978-0072228960 | Publication Date: May 16, 2003 | Edition: 2

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.

Editorial Reviews

From the Back Cover

Design T-SQL and SQLXML Solutions

Discover the key concepts, techniques, tips, and tricks professional developers need to know in order to take full advantage of stored procedures in the SQL Server environment. SQL Server 2000 Stored Procedure & XML Programming, Second Edition teaches you to manage SQL Server resources using Enterprise Manager, Query Analyzer, SQL Profiler, Visual SourceSafe, Visual Basic, and Visual Studio .NET. Learn basic and advanced XML with special focus on features that are in use in Microsoft database and development tools. Develop dynamic, Web-based applications using SQL Server's XML capabilities. This helpful resource contains simple explanations for developers who are just starting to work with stored procedures and XML, as well as advanced recommendations and techniques for experienced developers.

Essential Skills for Database Professionals

• Build user-defined, system, temporary, global temporary, extended, remote, and nested stored procedures
• Write code to interact with COM objects, DTS packages, executables, mail, the Registry, jobs, full-text indexes, and security
• Manage source code and deploy databases using T-SQL scripts or Visual Studio .NET tools
• Learn the finer points of using identity, timestamp, dynamically constructed queries, temporary tables, and more
• Master the latest features of XML for SQL Web Releases--XML BulkLoad, UpdateGrams, DiffGrams, SOAP, Web Services, XML Views, and OPENXML
• Access and modify databases through URL, POST, XML template, XPath queries, mapped XML schemas, and Web Services
• Develop .NET applications for SQL Server 2000 databases using SQLXML managed classes
• Sample scripts, .NET projects, databases, XML templates, and development and deployment tools available online

About the Author

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.

Product Details

• Paperback: 696 pages
• Publisher: McGraw-Hill Osborne Media; 2 edition (May 16, 2003)
• Language: English
• ISBN-10: 0072228962
• ISBN-13: 978-0072228960
• Product Dimensions: 9.1 x 7.2 x 1.5 inches
• Shipping Weight: 2.5 pounds (View shipping rates and policies)
• Average Customer Review: 4.5 out of 5 stars  See all reviews (10 customer reviews)
• Amazon Best Sellers Rank: #1,508,535 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

8 of 8 people found the following review helpful:

5.0 out of 5 stars The best information source, October 23, 2003

By 

Lana (New York, NY United States) - See all my reviews

This review is from: SQL Server 2000 Stored Procedure & XML Programming, Second Edition (Paperback)

An informative and comprehensive book.
A lot of realistic examples and suggestions that help to
solve complex and everyday SQL problems quickly.
I was able to make a database deployment process easier and faster using this book solution. One of the best book on the market for the SQL Server developers of all levels.

6 of 6 people found the following review helpful:

5.0 out of 5 stars Helps me earn my living!, October 8, 2003

By 

H. Keairns (Des Moines, IA United States) - See all my reviews
(REAL NAME)   

This review is from: SQL Server 2000 Stored Procedure & XML Programming, Second Edition (Paperback)

I am actually a BizTalk Server Developer but need frequent access to SQL Server data, preferably in XML. This great book has helped me jump over to writing stored procedures with being an SQL guru. It addresses things in a well organized way and saved me the cost of the book on Day 1. I like Dejan and appreciate his efforts.

5 of 5 people found the following review helpful:

5.0 out of 5 stars More than Just Stored Procedures!, June 15, 2004

By 

Sheldon Zola (Phoenix, AZ United States) - See all my reviews

This review is from: SQL Server 2000 Stored Procedure & XML Programming, Second Edition (Paperback)

If you write or maintain apps that use SQL Server or train people to do this, this book is a "must have"! Not just stored procedures, but triggers, user-defined functions, XML and more.

Sunderic includes not only "how", but "why and why not". Several ways to accomplish a given task are described, with pro's and con's for each. It's an INTERESTING book just to browse!