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 your Kindle here, or download a FREE Kindle Reading App.

SQL Server 2000 Developer's Guide (Database Professional's Library) [Paperback]

Michael Otey (Author), Paul Conte (Author)

Available from these sellers.

Amazon.co.uk Trade-In Store
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.

› See more product promotions

There is a newer edition of this item:

Microsoft SQL Server 2005 Developer's Guide
�24.64

In stock.

Product details

Paperback: 1008 pages
Publisher: Osborne/McGraw-Hill; Bk&CD-Rom edition (1 Jan 2001)
Language English
ISBN-10: 0072125691
ISBN-13: 978-0072125696
Product Dimensions: 23.1 x 19 x 6.9 cm
Amazon Bestsellers Rank: 4,421,856 in Books (See Top 100 in Books)

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

See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

› Visit Amazon's Michael Otey Page

Product Description

This text coaches the reader from beginning to advanced topics to increase their understanding of SQL Server 2000, and guides them to developing their own applications.

From the Back Cover

Build powerful, enterprise-wide database applications

SQL Server 2000 Developer's Guide explains how to access and manipulate data using Transact-SQL, build powerful Windows applications with ADO, DAO, and RDO, and develop integrated, cross-platform Web applications with ASP and XML. You'll also get details on SQL Server 2000 management, administration, and security issues. Plus, the bonus CD-ROM contains ready-to-run code and an evaluation edition of SQL Server 2000. This in-depth guide is a must-have for all serious SQL Server 2000 application developers.

-Master Transact-SQL's Data Definition Language (DDL) and Data Manipulation Language (DML)
-Accomplish complex data retrieval and manipulation tasks
-Write stored procedures, triggers, and functions to increase application functionality and simplify development
-
Develop database applications using Visual Basic, ActiveX Data Objects (ADO), Data Access Objects (DAO), and Remote Database Objects (RDO)
-Build data-driven Web applications with Active Server Pages
-Create cross-platform data transfer applications using XML
-Develop custom SQL Server management applications with SQL-Distributed Management Objects (DMO)
-Transfer objects and data between systems using SQL Server's Data Transformation Services (DTS)
-Expand application capabilities with SQL Server's full-text search and English Query features
-Plan and implement enterprise-wide security, backup, and restore procedures
-Includes SQL Server 2000 120-Day Enterprise Evaluation Edition on CD

See all Product Description

Inside This Book (Learn More)

First Sentence
In this chapter, you get an overview of the essential elements of Microsoft's SQL Server, starting with the big picture of SQL Server. Read the first page

Explore More
Concordance

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

There are no customer reviews yet on Amazon.co.uk.

5 star

4 star

3 star

2 star

1 star

Write a customer review

Most Helpful Customer Reviews on Amazon.com ^(beta)

Amazon.com: 15 reviews

19 of 20 people found the following review helpful

If you could only buy one book, this would be it... 21 Feb 2001

By F. M. Villafane - Published on Amazon.com

Format:Paperback

Excellent. Paul Conte and Mike Otey are well known in the Midrange AS/400 world for their concise, no-nonsense approach to programming the AS/400 in a variety of languages(i.e. C, RPG, SQL/400, etc.). Here, in the SQL Server world, starting with "SQL Server 7 Developer's Guide", and now for SQL Server 2000, they apply the same style and manner and succeed admirably. The book is chock-full of examples, and performance tips, and even includes a SQL primer! They leave no stone unturned, and cover every aspect of SQL DDL, DML, and T-SQL. Lastly, their coverage of OLEDB/ADO and XML completes the picture. As I said, if you could only buy one book on SQL Server 2000, this is the one to buy!

18 of 20 people found the following review helpful

The Best SQL Server 2000 book out there! 11 Jan 2001

By Catherine Martinson - Published on Amazon.com

Format:Paperback

This book really covers SQL Sever 2000 with clear, uncomplicated explanations and useful examples. I have used it as a reference guide to answer questions that have come up, as well as a jumping off point for writing my own applications to SQL Server 2000. I can cut and paste the code from the CD right into my programs.

The authors cover many of SQL Server 2000's features including: T-SQL's DDL and DML, stored procedures and triggers, ADO and ASP, XML, SQL-DMO, DTS, security, backup and recovery, and more. Having so much practical information all in one place has sure been a time saver for me.

A very well rounded and easy to read book. Definitely a must have!

10 of 10 people found the following review helpful

Good overall reference 5 Jan 2001

By Tina Clausen - Published on Amazon.com

Format:Paperback

This is a hefty book that so far looks like a good choice for my first SQL Server 2000 book. The core stuff on T-SQL and ADO is solid and does a good job on new features like cascading foreign keys. The additional topics are what have really made this book a good value for me. As examples, this is the first SQL Server book I've found that grapples with Windows 2000 Server Active Directory and how to use it with SQL Server security. The XML coverage is also top notch and got me over several hurdles quickly. Some of the admin areas, like backup and recovery, aren't covered as deeply as in books targeted specifically at DBAs, however.

The writing is very clear and direct and there's lots of example code. Although I've found a few typos, so far the technical information seems accurate. In several places, the authors provide useful tables that bring together information that's spread around different topics in the on-line documentation. I also found their recommendations for specific database settings and coding techniques helpful.

› Go to Amazon.com to see all 15 reviews

Were these reviews helpful? Let us know

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