CDN$ 39.68
  • List Price: CDN$ 62.99
  • You Save: CDN$ 23.31 (37%)
Usually ships within 3 to 5 weeks.
Ships from and sold by Amazon.ca.
Gift-wrap available.
Quantity:1
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

Microsoft SQL Server 2000 Programming by Example Paperback – Apr 17 2001


See all formats and editions Hide other formats and editions
Amazon Price New from Used from
Paperback
"Please retry"
CDN$ 39.68
CDN$ 39.68 CDN$ 3.49

2014 Books Gift Guide
Yes Please is featured in our 2014 Books Gift Guide. More gift ideas

Special Offers and Product Promotions

  • Join Amazon Student in Canada



Product Details

  • Paperback: 792 pages
  • Publisher: Que Publishing; 1 edition (April 17 2001)
  • Language: English
  • ISBN-10: 0789724499
  • ISBN-13: 978-0789724496
  • Product Dimensions: 18.3 x 4.1 x 23.1 cm
  • Shipping Weight: 1.3 Kg
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (15 customer reviews)
  • Amazon Bestsellers Rank: #2,251,737 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

From Amazon

Ideal for the database programmer or system DBA, Microsoft SQL Server 2000 Programming by Example is an excellent example-based tutorial on mastering today's SQL features. Packed with plenty of tips and tricks, this title will let almost anyone do more with SQL Server.

While there are plenty of screen shots showing graphical SQL Server tools, the focus of this book is clearly on learning real command-line Transact-SQL (T-SQL). The authors provide a patient and very thorough tour of T-SQL with full coverage of both basic and advanced features. You'll learn how to define new tables, manage users in groups, as well as perform all kinds of queries. Stand-out material includes an excellent guide to SQL data types and how to choose the right one for your needs. When it comes to queries, the book does a great job of exploring all your options for joining relational data, as well as grouping data for more advanced reporting. True to its title, Microsoft SQL Server 2000 Programming by Example is filled with dozens of examples of SQL commands (and the results) so that you can try out this material for yourself and really learn the language thoroughly.

Later on, the authors turn toward server-side programming with a digestible guide to creating stored procedures and triggers. The book closes with an in-depth guide to the issues regarding cursors (for working with table data), transactions and locking. Sections on bulk copy tools and the Microsoft Data Transformation Services (DTS) show how to move data around the enterprise. A final section of distributed queries and linked servers will help you work with different sources of data wherever it resides in your organisation.

Despite some stilted writing, the comprehensive examples in this book make it a success. It will let anyone start using basic T-SQL for the first time, as well as teach more advanced readers to master the finer points of Microsoft databases. --Richard Dragan

From the Publisher

SQL Server 2000 Programming by Example provides clear and concise examples of basic programming techniques used in SQL Server 2000 primarily using Transact-SQL. Even if you're a complete novice to SQL Server 2000 programming, you will benefit by reading through the book's logical process. SQL Server 2000 is introduced and explored, database structure is designed and built, and finally a variety of programming techniques are studied and reviewed. If you are already familiar with SQL Server 2000 programming, you may use the book as a quick reference guide that provides plenty of pertinent examples.

Get up to speed on SQL Server 2000 and how to take full advantage of new features

Customer Reviews

4.5 out of 5 stars
Share your thoughts with other customers

Most helpful customer reviews

By Mel Mullen on Aug. 20 2002
Format: Paperback
You know one of those reference books you buy but no matter how often you look at it it never has the answer to your questions? Yes? Well this book is one of those.
As a professional software developer I never had much use for Que books - thick paper, too much white space, and big fonts. This book is no exception. I made the mistake of buying it on the strength of the reviews at Amazon but it lives up to the Que tradition of being a book full of basic information, most of which is available in the SQL server docs. Sure it has lots of examples but little that is very enlightening.
I didn't get the impression here that this was a basic book but it is. It is going to be a disappointment to you if you, like me, already know SQL/DBMS programming but from another database product. If I was starting out then maybe I'd find it of use, but a one-stop answer to all you SQL Server problems it most definitely is not. If I ever find it useful I will come straight back here and change this review.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
Format: Paperback
With previous experience (v7.0) I found this book an excellent guide to the added functionality of v2000.
It's concisely, cleanly written in a straightforward no-nonsense style. The lay out is logical and well planned with the book building nicely as you move through it.
I have also found it deep enough to fill some gaps and clarify areas that I previously felt I knew very well.
The main advantage of the book to my mind though is that it does exactly what it says on the cover - it provides pratical examples of all the concepts discussed (I have found that previous books have often left me feeling "OK, but lets see it in action!!!" including Soukup & Delaney's excellent "Inside SQL Server 7".
All round an excellent book, highly recommended at a very reasonable price.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
Format: Paperback
I have been working more than four years with SQL Server, since version 6.5. In my work I have to cover all the funcionality in SQL Server as I am developer, administrator and so on. I have few SQL books as I find is quite simple to find almost anything in the BOLs.
But this book is the best I have ever seen to get into SQL Server and improve your skills, from the point of view of a developer there is not better book. It is also a incredible source of information for experts, it really explores all the new features you can find in SQL Server 2000.
I also know the two authors's work as they help many people in the SQL forums and I can say they are really good.
Enjoy it!!!
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
By Frank on Aug. 1 2001
Format: Paperback
I have finally found an author and book that are outstanding in the T-SQL arena. I have been searching for the last 2 years for a book I could teach an Introductory College level course from and wallla ... here it is....
My students are elated at the ease of navigation. The book is extremely well written. The test scores have nearly doubled since I switched to this book. The students are retaining more information and I even learned a few more tricks. Great book!
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
Format: Paperback
Although not entirely sufficient as preparation for the SQL Server Design exam, it certainly helped me along that path, and in a much more enjoyable way than many of those dry certification-prep books which assume significant prior knowledge and do little in the way of skill-building. This book is also excellent for non-certification people wanting to learn to program SQL Server. I found it to be authoritative and very readable.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
Format: Paperback
When we needed to get up to speed on SQL Server 2000, we wrestled with the pros and cons of several books before deciding on this one. And it has lived up to billing, provide clear concise instruction on the ins and outs of SQL Server 2000, with excellent examples to reinforce the concepts. For those new to SQL and SQL Server 2000 specifically, a must have!
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
By A Customer on April 21 2004
Format: Paperback
There is nothing in this book that you cannot find in many readily available sources mostly the Books Online. I learned nothing from this book and neither would most people. After reading this book one thing is certain: These authors have never built truly complex Sql applications. If you are a beginner get this book. If not keep looking.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
By Maamoun Khalil on Aug. 16 2003
Format: Paperback
This is an excellent book for average/advanced programmers who
want to review and learn all about SQL Server 2000 basics with very good and very concise,very clear examples.I recommend this book for people preparing for the Microsoft 70-229 database design and implementation.A must READ. I thank the authors.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.


Feedback