Professional SQL Server 2000 Programming and over one million other books are available for Amazon Kindle. Learn more
CDN$ 71.99
Usually ships within 1 to 3 weeks.
Ships from and sold by
Gift-wrap available.
Professional SQL Server 2... has been added to your Cart
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

Professional SQL Server 2000 Programming Paperback – Nov 15 2000

See all 3 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
"Please retry"
CDN$ 71.99
CDN$ 12.25 CDN$ 8.25

There is a newer edition of this item:

Product Details

  • Paperback: 1440 pages
  • Publisher: Wrox; 1 edition (Nov. 15 2000)
  • Language: English
  • ISBN-10: 0764543792
  • ISBN-13: 978-0764543791
  • Product Dimensions: 18.8 x 6.7 x 22.9 cm
  • Shipping Weight: 1.8 Kg
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (66 customer reviews)
  • Amazon Bestsellers Rank: #1,455,308 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

From Amazon

When it comes to selecting computer books, deciding which book to buy can sometimes be even more confusing than the software it is written about. However, if you are looking for a book to instruct you on the use of SQL Server 2000, choosing this book, Professional SQL Server 2000 Programming, could well simplify your selection process.

In addition to providing a thorough treatment of SQL Server 2000 development, Robert Vieira's extensive reference also devotes quite a lot of space to covering SQL in general and issues relating to database design. Included is a complete introduction to Transact-SQL and an excellent chapter on normalisation that will go a long way for many to de-mystify the mystery of an over-referenced but much misunderstood database design concept. There is also in-depth information on the new features of SQL Server 2000, including indexed views, user-defined functions and support of XML. Sadly, there is no accompanying CD, but source code for the book can be downloaded from the Wrox Web site.

While you don't need any knowledge of SQL Server or database administration to make the most of this book, you will need a reasonable understanding of programming fundamentals. That said, the author's down-to-earth style makes it possible for anyone with some programming background and the will to learn, to really get to grips with SQL Server 2000 development. If you are looking for a book that combines rich content with clear explanation, then look no further than this excellent title. --Peter Lunn --This text refers to an out of print or unavailable edition of this title.

From the Publisher

This book is a revised follow on from Professional SQL Server 7.0 Programming, to address the new features of this recent release. With a general understanding of programming principles, (eg familiarity with VB, C++, VB Script) Professional SQL Server 2000 Programming provides a comprehensive overview of the new areas of SQL Server, for programmers. There is an in-depth discussion of T-SQL, the query language of Microsoft SQL Server. From basic database design concepts a tutorial explains more advanced topics and specific areas including Stored Procedures and Advanced Queries. Advanced topics - performance tuning, security and a solid description of OLAP, which is built in with SQL Server, are then introduced. The new XML features are explored to provide an understanding of this important area. With over 1,500 pages this book covers the main topics to provide an in-depth understanding of concepts and procedures, so you can get the most out of SQL Server 2000. --This text refers to an out of print or unavailable edition of this title.

Inside This Book (Learn More)
First Sentence
SQL Server 7.0 was a major leap forward from SQL Server 6.5. 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

4.2 out of 5 stars

Most helpful customer reviews

Format: Paperback
Occasionally I have the need to leave my IBM/Lotus programming platform and interact with data stored in Microsoft SQL Server 2000. I even have it running on my laptop as a higher-end alternative to Access. I found that the book, Professional SQL Server 2000 Programming by Robert Vieira (Wrox) is a very good reference for manipulating data in that environment.
Vieira concentrates specifically on the programming aspects of SQL Server 2000 as opposed to teaching you how to administer the server. He does touch on an administration overview in chapter 30, but it's not something you'd read in order to pass an administration exam. Although the title does say "Professional", this does not mean you have to be a veteran SQL programmer to benefit from it. The earlier chapters cover the fundamentals of RDBMS technology, as well as how SQL is used in a SQL Server 2000 environment. The further you get into the book, the more you'll find subjects that are either more advanced or cover techniques you'll use in application development, such as how to build triggers and stored procedures. While you will learn all these skills within the SQL Server 2000 platform, the core technologies are transferable to just about any RDBMS. Time spent with this book will continue to pay off regardless of what database system you need to use at any given time.
While the content is technical, the writing style is conversational and approachable. It's actually quite easy to read the material and digest the concepts without trying to fight against the author's style. If you have need to work with SQL Server 2000 from a development standpoint, this is definitely a book to consider to guide you along the way.
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
Rob is a natural at teaching his craft, which he knows extremely well. You can tell he is a professional that has mastered his craft and enjoys sharing the information that is essential for anyone to become a true professional in the field. Rob is also very honest. Some writers mention this book v. the 7.0 book not being different? Rob addresses this in the first few pages of this book, as an honest and good man would. You see, there are more differences between 7.0 and 2000 than some people have picked up on is what I believe. Sure there is much similar information. That packaging, title and Rob's own words are quick to show and tell you that. But all in all it was worth a new book for the 2000 upgrade. In fact, there are some MAJOR changes in 2000, so it's worth it just to learn about those and the same great in depth information. I've noticed a second edition of this title but can never find it available. I own this version from the year 2000, and believe me it is ragged from constant use, but would pay for the second editon if I could find it just for any new information Rob has to dispense. I feel this informtion is so well presented and such a great all around tutorial, reference, guide, all in one book I'd pay for the updated info in a second editon gladly.
Thanks Rob. I personally think you are the best. I wish I worked for you! You are not only a master and completely professional, but you have that magic quality of not being full of yourself in any manner and humble in fact....a very admirable trait.
A reader who is appreciative and better for your great work.
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 May 8 2004
Format: Paperback
This book is worth it's weight in gold. The expert explanations surpass a basic coverage and give you a balance of sterling explanation and vivid examples, which is something many authors lack the ability to do.
The coverage of of all other modules that come with SQL server 2000 is better than any out there and a must for a developer using SQL server 2000. I was able to write some awesome SQLXML code directly from this book that allowed us to roll out reporting to our users with no client side worries. This is the best intro to XML as you will find. Obviously XML, OLAP and other topics like this need further discussion in full editions, but the author is quick to point that out and gives you just what you need to get started and tells you the best places to find continuing information.
SQL 2000 is so different from version 7.0, this book was rightfully not titled as an edition of the 7.0 book. They are two different animals. Rob has written a followup to this book and it's correctly titled the same as the 2000 book, 2nd edition. I'm so eager for it to be in stock. It must be a very popular book. I would pay full price for it knowing it's a second edition. That is how good Rob is at doing what he does. Any new information from someone as expert as Rob is worth the price.
Don't hesitate picking this one up if you want the best SQL 2000 programming book on the market. Again, anyone knows the supporting technologies of SQL SERVER are not able to be fully covered in one book, but an solid introduction into what they can do and beyond in most cases, is essential to a book of this integrity and usefulness.
Other authors write several SQL server books, change the title slightly and sell them as new books.
Read more ›
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 bradw2k on Jan. 16 2004
Format: Paperback
For a developer with weak or mediocre SQL Server skills, this is the best place to go. It is very readable without being too wordy, and the coverage is awesome, actually much wider than is needed for the 70-229 exam. Amazingry this book is both exactly what I need as a professional developer AND exactly what I needed to pass 70-229. (I should mention that for that exam you need to be very familiar with the command line and GUI tools and options, DBCC etc, which are covered by this book.)

I cannot imagine a better SQL Server 2000 "bible" for developers. It's true it lacks super advanced information on performance tuning, OLAP, and DTS, but all of these topics are covered well enough for the needs of a professional developer who is not on a specialty project and is not acting as a power DBA. And to add more of such advanced details, cutting out fat to make room would not be an option, because there is no fat in this book, it is already 1400 pages because it covers everything. Unless you are already a SQL Server expert, I think you shouldn't go without this 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.

Most recent customer reviews