- Paperback: 277 pages
- Publisher: Microsoft Press,U.S.; Pap/Com edition (1 Jun 2001)
- Language English
- ISBN-10: 0735613699
- ISBN-13: 978-0735613690
- Product Dimensions: 23.1 x 18.5 x 2.5 cm
- Average Customer Review: 4.0 out of 5 stars See all reviews (1 customer review)
- Amazon Bestsellers Rank: 2,826,204 in Books (See Top 100 in Books)
- See Complete Table of Contents
| |||||||||||||||
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
|
There is a newer edition of this item:
|
Product details |
More About the Author
Product Description
Amazon.co.uk Review
For any developer who wants to do more with XML and databases on Windows, Programming Microsoft SQL Server 2000 with XML provides an up-to-date guide to some current XML tools and features available on the Microsoft platform. This example-packed book can let you get more productive with the latest generation of SQL Server tools.
After a quick tour of what XML means for business today, this text jumps right in with a tutorial on using XML in Microsoft Transact-SQL (T-SQL) supported in SQL Server. The author provides nuts-and-bolts information on querying databases and returning XML, along with different options for formatting XML data.
Next comes a tutorial for using ActiveX Data Objects (ADO), the preferred standard for programming with databases in Windows, and how to use XML within this API. Short code excerpts will show you how to perform common programming tasks quickly. The support for XML in Microsoft doesn't stop there, of course, and the book next focuses in on support for Web publishing in SQL Server through XML. This powerful feature shows you how to define templates that can be used to query and update data via HTTP using URLs. Sections on mapping schemas show how XML can used to move data between different database schemas. An important section on the T-SQL OpenXML function to perform a range of database tasks, including inserting XML data in bulk into database tables.
In its closing sections, this text illustrates key technologies using a nicely functional online computer store complete with shopping basket, product catalogue, and simulated order processing all using XML techniques demonstrated earlier on.
In all, this book delivers a solid tour of what's available in SQL Server, ADO, and other Microsoft tools and technologies. Suitable for any Windows IT professional who works with databases, this title is a capable tutorial and guide to what's out there today with XML on the Microsoft platform. --Richard Dragan
Product Description
Extensible Markup Language (XML) is the lingua franca of business information exchange. And with "Programming Microsoft SQL Server 2000 With XML," developers get the expert guidance they need to build powerful, XML-enabled database applications for line-of-business, e-commerce, and the Web. Server databases are the core engines driving business in the Internet economy, and this practical guide focuses on how to exploit the built-in XML functionality, scalability, and speed in SQL Server 2000 within different business and technological scenarios -- including how to apply what you already know about HTTP and other standards -- for best advantage. The author steps through the development of several real-world solutions, including enterprise knowledge-management systems and ultrascalable electronic retail and business-to-business (B2B) solutions. All the book's code appears on the companion CD-ROM so readers can study and reuse them for their own projects.
Inside This Book
(Learn More)
First Sentence
The Internet is changing the way we do business. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
The Internet is changing the way we do business. Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
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
Most Helpful Customer Reviews
4 of 4 people found the following review helpful
Format:Paperback
This is a great book for getting up to speed quickly on the new XML features of SQL Server 2000.
The pace is excellent for experienced SQL Server programmers or DBAs but would probably be a bit tough for a novice user (but it does make this very clear at the beginning of the book). It assumes that you are already familiar with programming SQL Server and have at least some XML knowledge.
One or two areas are glossed over a bit, such as no mention of the XML View Mapper and there could be more details on using XPath but other than that this book is highly recommended.
The pace is excellent for experienced SQL Server programmers or DBAs but would probably be a bit tough for a novice user (but it does make this very clear at the beginning of the book). It assumes that you are already familiar with programming SQL Server and have at least some XML knowledge.
One or two areas are glossed over a bit, such as no mention of the XML View Mapper and there could be more details on using XPath but other than that this book is highly recommended.
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
7 reviews
25 of 25 people found the following review helpful
It's about time
13 Jun 2001
Format:Paperback
Let's see. SQL Server 2000 has been out for quite some time now. One of the neat features of SQL Server 2000 is XML. Yet, all of the tomes written so far offer nothing more than a cursory glance.
Note, that I am not criticizing the authors of these works for this oversight. Much of the blame lies in Microsoft not having the XML features complete until the very latest betas (release candidates actually, but who is counting).
One of the features with the most promise, updategrams, has not been covered at all (except a mention here and there and a snippet of how the XML is formatted).
Also of note is the documentation of the FOR XML EXPLICIT mode. The 13 pages on this subject give a good intro to get up and going. You will still have to pound out the queries (and probably cuss a bit), but it is nice to finally have some documentation (even the books online were poor here).
A word of warning. This is not a book about how to use SQL Server 2000. It is a very specialized work on SQL Server 2000 and XML. If you want to learn SQL Server 2000, it would be best to look elsewhere.
I would like to give the book a five star rating, but there are areas where I feel the material is a bit too thin. On the other hand, this work is enough to be worth the money spent if you are developing in SQL Server 2000 and XML.
6 of 6 people found the following review helpful
Make sure you buy the 2nd Edition
21 Nov 2002
Format:Paperback
Most of the reviews here seem to relate to the first edition (which was admittedly kind of short). The book has been updated, and the second edition covers new stuff like XSD Schemas, Diffgrams, SOAP Virtual Names, and all the other SQLXML 3.0 features. I found the book really useful, and easy to read. The examples are great and the concepts are all well explained. Definitely worth buying if you're planning to use SQL Server's XML functionality.
5 of 6 people found the following review helpful
Good! And rapid.
21 Oct 2001
Format:Paperback
I never expected so much useful information into such a small book. Good books don't sell by weight or page count.
I found this book concise and clear (this man knows how to teach). It sure doesn't explain everything about the subject, but it gives the big picture, with an impressive number of details too.
Ideal to start working in small time.
NOTE about who is this book for:
As title state, this book teaches how to use the XML features of SQL Server 2000, not how to use SQL2000, so if you don't know SQL Server you better read something else first.
From the XML XSL XPath X... side, this book is also for novices as it has a very good appendix that teaches all you need to understand the book.
I found this book concise and clear (this man knows how to teach). It sure doesn't explain everything about the subject, but it gives the big picture, with an impressive number of details too.
Ideal to start working in small time.
NOTE about who is this book for:
As title state, this book teaches how to use the XML features of SQL Server 2000, not how to use SQL2000, so if you don't know SQL Server you better read something else first.
From the XML XSL XPath X... side, this book is also for novices as it has a very good appendix that teaches all you need to understand the book.
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
