Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

SQL Server 2000 Developer's Guide (Database Professional's Library) Paperback – 1 Jan 2001

See all formats and editions Hide other formats and editions
Amazon Price New from Used from
"Please retry"
£27.45 £5.71

There is a newer edition of this item:

Trade In Promotion

Product details

More About the Author

Discover books, learn about writers, and more.

Product Description

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

About the Author

Michael Otey (Portland, OR) is a Senior Technical Editor of SQL Server Magazine and Windows NT Windows Magazine. He is also the presient of TECA, a consulting and software development company.

Paul Conte (Eugene, OR)is an established database expert and author of many books. He is also the president of Picante Software.

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
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

There are no customer reviews yet on Amazon.co.uk.
5 star
4 star
3 star
2 star
1 star

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 14 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 Amazon Customer - 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.
13 of 14 people found the following review helpful
SQL Server Bible! 9 Jan 2001
By Mel Beckman - Published on Amazon.com
Format: Paperback
If you've tried finding answers about SQL Server on Microsoft's Web site, you already know that Microsoft's documentation is a mishmash of manuals, technical notes, and forum discussions. It's virtually impossible to get a clear picture of how to use SQL Server from this stuff. SQL Server 2000 Developer's Guide is a great "master index" to SQL Server 2000 -- it covers everything! But more than that, it provides complete, _working_ examples on the accompanying CD, which is a vast improvement over Microsoft's unusable code "snippets." I especially like the charts that relate SQL Server features to tasks and capabilities. This makes it easy to figure out what SQL thing to use to accomplish a particular task. Better, the book gives you step-by-step procedures so that you do things in the right order, rather than thrashing around in Microsoft's peculiar dialog boxes. This book doesn't cover every aspect of SQL Server in detail -- it's an essential adjunct to Microsoft documentation rather than a replacement for it. But I never needed a replacement to the manuals, just a map with example code and lots of helpful tips. That's what SQL Server 2K DevGuide is!
9 of 9 people found the following review helpful
Full subject reference with succinct, to the point practices 10 Jan 2001
By A Customer - Published on Amazon.com
Format: Paperback
I found this book to be an excellent resource in understanding the proper methods for deploying SQL Server 2000 in the development of applications. The orientation of the material is to frame the subject matter in a concise, meaningful conceptual overview and then to step you through clearly written sequence of techniques for doing the work.
Along the way, as the writers uncover key issues and choices in the methods, they state perferred paths through the thicket of options. You get the benefit of experience and confidence in their reporting because they have included a CD of the code they have used in the book.
The book is host to all the subjects a developer using this software requires -- from the Transact-sql query language and application interface coding to management of applications. Older programming standards for interfacing an application with SQL Server are given thorough coverage and will help preserve continuity in coding made previously with earlier versions of SQLServer. At the same time, the new Microsoft initaitives in ADO are given in depth treatment as well.
Were these reviews helpful? Let us know