Professional SQL Server 2000 Programming and over one million other books are available for Amazon Kindle. Learn more

Vous voulez voir cette page en français ? Cliquez ici.

Sign in to turn on 1-Click ordering.
Amazon Prime Free Trial required. Sign up when you check out. Learn More
More Buying Choices
Have one to sell? Sell yours here
Start reading Professional SQL Server 2000 Programming on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Professional SQL Server 2000 Programming [Paperback]

Robert Vieira
4.2 out of 5 stars  See all reviews (66 customer reviews)
List Price: CDN$ 71.99
Price: CDN$ 45.35 & FREE Shipping. Details
You Save: CDN$ 26.64 (37%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock (more on the way).
Ships from and sold by Gift-wrap available.
Want it delivered Tuesday, September 23? Choose One-Day Shipping at checkout.


Amazon Price New from Used from
Kindle Edition CDN $43.08  
Paperback CDN $45.35  
There is a newer edition of this item:
Professional SQL Server 2005 Programming Professional SQL Server 2005 Programming 1.0 out of 5 stars (1)
CDN$ 37.79
In Stock.
Join Amazon Student in Canada

Book Description

Nov. 15 2000 Programmer to Programmer
What is this book about?

SQL Server 2000 is the latest and most powerful version of Microsoft's data warehousing and relational database management system. This new release is tightly integrated with Windows 2000 and offers more support for XML, as well as improved Analysis Services for OLAP and data mining.

Professional SQL Server 2000 provides a comprehensive guide to programming with SQL Server 2000, from a complete tutorial on Transact-SQL to an in-depth discussion of new features, such as indexed views, user-defined functions, and the wealth of new SQL Server features to support XML. Whether you're coming to SQL Server 2000 from another relational database management system, upgrading your existing system, or perhaps wanting to add programming skills to your DBA knowledge, you'll find what you need in this book to get to grips with SQL Server 2000 development.

What does this book cover?

Here are just a few of the things covered in this book:

  • A complete introduction to Transact-SQL
  • Database design issues
  • Creating and using views, stored procedures, and user- defined functions
  • Responding to events with triggers
  • Making your SQL Server secure
  • Retrieving your data as XML
  • An introduction to Analysis Services
  • Moving data using Data Transformation Services and the bulk copy program
  • Maintaining the integrity of distributed data with replication

Who is this book for?

This book is aimed at the SQL Server developer who wants to make the most out of the new features of SQL Server 2000. No knowledge of SQL Server is assumed, although in order to follow this book, you do need to have an understanding of programming basics such as variables, data types, and procedural programming. Database administration is also covered but only as it affects the SQL Server developer.

Product Details

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

Most helpful customer reviews
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?
By A Customer
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?
5.0 out of 5 stars Rob has written a masterpiece May 8 2004
By A Customer
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?
5.0 out of 5 stars Can't be beat Jan. 16 2004
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?
Want to see more reviews on this item?
Most recent customer reviews
5.0 out of 5 stars Best Book By Far....
I've read the MSPress Certification book, BOL (SQL server Books Online), and neither come close to the under standing this book gives. Read more
Published on July 14 2004
5.0 out of 5 stars Best sql server programming book
This is a very good book for sql server programmers. Not like the other books where you find lots of cut and paste from BOL. Read more
Published on July 9 2004 by ravi lobo
3.0 out of 5 stars Stuck to my earlier edition
I agree with the reviewer Wendt, who complained that this book is too much like its earlier edition. Read more
Published on May 17 2004 by Alois van Klinken
5.0 out of 5 stars Best book on SQL 2000 programming available
This book covers everything a professional programmer using SQL server 2000 needs to know in just the right depth and breadth of topics. Can't beat it. Read more
Published on May 10 2004
2.0 out of 5 stars Decent but flawed
This book has some good info, but the book itself has many flaws.
First, much of the info is copied verbatim from the 7.0 book. Read more
Published on May 4 2004 by Seniel Wendt
4.0 out of 5 stars Great book
This book covers the client side of Sql Server application development extremely well. It covers nearly all the client side technolgies and provides real-world examples for putting... Read more
Published on May 1 2004 by Lyle Edwards
4.0 out of 5 stars Must Have SQL Server 2000 Book
This is THE book to have on SQL Server 2000. Robert Vieira unquestionably knows his stuff and covers every aspect of SQL Server completely and thoroughly.
Published on Feb. 12 2004 by Terry Smith
1.0 out of 5 stars Don't bother
Like another review, I find the 'Professional' in the title inappropriate. I'm an experienced SQL developer and I quickly discovered that there was never anything in here that I... Read more
Published on Jan. 7 2004
5.0 out of 5 stars The required book to pass the MCP 70-229 exam
If you need to understand the FUNDAMENTALS of SQL Server 2000 then read this book. Also if you are preparing for the MCP 70-229 exam, this book is a required read. Mr. Read more
Published on Oct. 8 2003 by Maamoun Khalil
Search Customer Reviews
Only search this product's reviews

Look for similar items by category