Join Amazon Prime and ship Two-Day for free and Overnight for $3.99. Already a member? Sign in.

Quantity:

More Buying Choices

36 used & new from $1.73

Have one to sell? Sell yours here

Tell the Publisher! I�d like to read this book on Kindle Don�t have a Kindle? Get yours here.

SQL Server 2000 Stored Procedure & XML Programming, Second Edition (Paperback)

by Dejan Sunderic (Author) "Welcome to SQL Server 2000 Stored Procedure & XML Programming..." (more)
Key Phrases: expired lease schedule, make varchar, deferred name resolution, Query Analyzer, Enterprise Manager, Visual Studio (more...)

4.5 out of 5 stars See all reviews (10 customer reviews)

List Price:	$49.99
Price:	$34.99 & this item ships for FREE with Super Saver Shipping. Details
You Save:	$15.00 (30%)

Upgrade this book for $9.99 more, and you can read, search, and annotate every page online. See details

In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

Only 4 left in stock--order soon (more on the way).

Want it delivered Thursday, July 16? Choose One-Day Shipping at checkout. Details

18 new from $9.23 18 used from $1.73

There is a newer edition of this item:

Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET 4.0 out of 5 stars (12)
$37.79

In Stock.

What Do Customers Ultimately Buy After Viewing This Item?

	67% buy the item featured on this page: SQL Server 2000 Stored Procedure & XML Programming, Second Edition 4.5 out of 5 stars (10) $34.99
	27% buy The Guru's Guide to SQL Server Stored Procedures, XML, and HTML 4.6 out of 5 stars (82) $43.86
	6% buy SQL Server 2000 XML Distilled 4.5 out of 5 stars (10) $49.99

Explore similar items

Frequently Bought Together

Customers Who Bought This Item Also Bought

Microsoft SQL Server 2000 Unleashed (2nd Edition)

by Ray Rankins

4.3 out of 5 stars (28) $50.80

SQL Server 2000 Stored Procedure Programming

by Dejan Sunderic

3.3 out of 5 stars (57) $49.45

The Object-Oriented Thought Process (3rd Edition) (Developer's Library)

by Matt Weisfeld

4.1 out of 5 stars (43) $35.09

SQL Server 2000 Stored Procedures Handbook (Expert's Voice)

by Tony Bain

5.0 out of 5 stars (1) $32.57

Web Services A Technical Introduction (Deitel Developer Series)

by Harvey M. Deitel

3.8 out of 5 stars (5) $39.99

› Explore similar items

Editorial Reviews

Product 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.

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

See all Editorial Reviews

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.com Sales Rank: #670,298 in Books (See Bestsellers in Books)
Popular in these categories: (What's this?)
#29 in Books > Computers & Internet > Databases > XML & Databases
#37 in Books > Computers & Internet > Certification Central > MS SQL Server

Would you like to update product info or give feedback on images?

Inside This Book (learn more)

First Sentence:
Welcome to SQL Server 2000 Stored Procedure & XML Programming. Read the first page

Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
expired lease schedule, make varchar, deferred name resolution, commit transaction return, insert inventory, model varchar, original stored procedure, set nocount, rollback transaction return, sysobjects table, invalid object name, distributed partitioned views, annotated schemas, complete result set, insert equipment, extended stored procedure, federated servers, xml auto, temporary stored procedures, schema validator, rowset provider, tempdb database, denormalized table, int identity, indexed views

Key Phrases - Capitalized Phrases (CAPs): (learn more)
Query Analyzer, Enterprise Manager, Visual Studio, Visual Basic, Create Trigger, Inventory Inventoryid, Toshiba Portege, Server Books Online, Object Browser, Contact Contactld, Internet Explorer, Server Agent, Alter Trigger, Imports System Imports System, Module Modulel Sub Main, Alter Table, Create Function, Web Assistant, Enterprise Edition, Imports Microsoft, Null Null, Solution Explorer, Cancel Help, Rows Executes, After Update

New!
Books on Related Topics | Concordance | Text Stats

Citations (learn more)

This book cites 1 book:

Basic Operations by Bergwall Productions Inc. on page 31

1 book cites this book:

Portable DBA: SQL Server by Damir Bersinic on page 91

Books on Related Topics (learn more)

MCAD/MCSE/MCDBA Self-Paced Training Kit by Microsoft Corporation

Discusses:

Transact-SQL Desk Reference by Deac Lancaster

Discusses:

The Guru's Guide to SQL Server Stored Procedures, XML, and HTML by Ken Henderson

Discusses:

MCSE by Marc Israel

Discusses:

Tags Customers Associate with This Product

(What's this?)

Click on a tag to find related items, discussions, and people.

sql server(1)

See all 2 tags...

Help others find this product — tag it for Amazon search

No one has tagged this product for Amazon search yet. Why not be the first to suggest a search for which it should appear?

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

Customer Reviews

10 Reviews

5 star:		(7)
4 star:		(2)
3 star:		(0)
2 star:		(1)
1 star:		(0)

Average Customer Review

4.5 out of 5 stars (10 customer reviews)

Share your thoughts with other customers:

Create your own review

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 "obaranova" (New York, NY United States) - See all my reviews

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.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

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)

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.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

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

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!

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

Share your thoughts with other customers: Create your own review

› See all 10 customer reviews...

Most Recent Customer Reviews

4.0 out of 5 stars Good but Missing Query Reference
I'm a developer with a degree in CS and 10 years' experience. I bought this book for an SQL Server 2000 project, because I've got more experience with mysql which has slightly... Read more

Published on March 25, 2007 by M. Shaw

4.0 out of 5 stars Matthew Reinbold on behalf of the Salt Lake City ColdFusion User's Group (SLCFUG)
-as read by Mike Tazelaar

This is an informative and comprehensive book.
There are many realistic examples and suggestions that help solve complex and everyday... Read more

Published on September 6, 2005 by Matthew Reinbold

2.0 out of 5 stars Disapointed reader
My choice of this book was based on the reviews written here. After reading the book i wonder if the reviewers actually read the book. Read more

Published on September 30, 2004 by Tronic

5.0 out of 5 stars Lucid and thorough -- VERY worthwhile
It bothers me that many of the best books on the latest Microsoft technology (.Net, SQL Server) are written by non-native-English speakers. Read more

Published on July 9, 2004 by Jeffrey J. Breitman

5.0 out of 5 stars Great resource for SQL/XML
Extremely helpful for SQL/XML. Great examples. Very simple to understand. Author has an interative way of writing. Last 4 chapters are a must read for any SQL developer.

Published on June 20, 2004 by simranjindal

5.0 out of 5 stars Good value - TSQL book and SQLXML book in one
Easy to understand; down to earth.
Everything that you need for stored procedure development - from naming conventions to methods to deploy changes in production. Read more

Published on October 24, 2003 by Ted Ward

5.0 out of 5 stars This book is great!
This book is the proverbial bomb! The cover is superb and the binding job is excellent. It is filled with many pages with much writing that covers topics. Read more

Published on May 22, 2003

› See all 10 customer reviews...

.jsOffDisplayBlock { display: block; } .jsOffDisplayInline { display: inline; } .jsOffVisibility { visibility: visible; } .jsOnDisplayBlock { display: none; } .jsOnDisplayNoneBlock { display: block; } .jsOnDisplayNoneInline { display: inline; } .jsOnDisplayInline { display: none; } .jsOnVisibility { visibility: hidden; } .jsOnDisplayBlock { display: none; } .jsOnDisplayInline { display: none; } .jsOnVisibility { visibility: hidden; }