Programming Books C Java PHP Python Learn more Browse Programming Books
Advanced Transact-SQL for SQL Server 2000 and over one million other books are available for Amazon Kindle. Learn more
Buy Used
$4.98
Condition: :
Comment: **FAST SHIPPING!!** 100% satisfaction guaranteed!!** Looks like a typical used book with some shelf wear and possibly a Library marking, binding or plastic dust jacket** We carefully inspected this item**
Have one to sell? Sell on Amazon
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

Advanced Transact-SQL for SQL Server 2000 Paperback – November 27, 2000


See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$12.99 $0.92
NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 814 pages
  • Publisher: Apress; 1st edition (November 27, 2000)
  • Language: English
  • ISBN-10: 1893115828
  • ISBN-13: 978-1893115828
  • Product Dimensions: 2.2 x 7.5 x 9.5 inches
  • Shipping Weight: 3.8 pounds
  • Average Customer Review: 2.2 out of 5 stars  See all reviews (80 customer reviews)
  • Amazon Best Sellers Rank: #3,087,482 in Books (See Top 100 in Books)

Editorial Reviews

Review

"Whether you are an experienced SQL Server developer or just starting, this is a must-have." -- British Computer Society, September 2001

About the Author

Itzik Ben-Gan is a senior SQL Server instructor and consultant with 10 years of experience in networking, development, databases, and data warehousing. He is a popular columnist and contributing editor for SQL Server Magazine. Highly certified, he is also a Microsoft Certified Trainer (MCT), a Microsoft Certified Systems Engineer + Internet (MCSE+1), a Microsoft Certified Solution Developer (MCSD), a Microsoft Certified Database Administrator (MCDBA), and a Microsoft SQL Server "Most Valuable Professional".

Tom Moreau, Ph.D. is an MCSE, MCDBA, and independent consultant specializing in Microsoft SQL Server database administration, design, and implementation, based out of the Toronto area. Tom is an SQL Server "Most Valuable Professional" and writes the monthly "Dr. Tom's Workshop" column for Pinnacle Publishing's SQL Server Professional newsletter.

Customer Reviews

There are far too many things that appear far to similar to the BOL.
Peni Jones
I could see this book being helpful to the brand new beginner, but I don't think it's very useful for anyone else.
Wallace Cranton, Jr.
These guys should not be writing books about Transact-SQL, they should be reading them.
Collin Hornfield

Most Helpful Customer Reviews

22 of 22 people found the following review helpful By Kevin Daugherty on April 1, 2002
Format: Paperback
I was a little surprised when I read some of the negative reviews on this book. It has become the most used book in my library of late and I find it very helpful and easy to use. The code examples are short, clear and to the point. The topics are well indexed and logically grouped, making it very easy to find examples of what I need to know. So many other books in this category are designed for either Database Administration or Developers embedding SQL in applications. This book is aimed at people who code SQL in MS SQL Server. It focuses on how to write the most optimized queries and gives practical tips that make it easier to write and debug SQL.
I am somewhere in between a Beginner and an Advanced user. I have been coding simple embedded SQL for 5 years as a VB developer and recently writing more complex stored procedures. This book has been the most practical SQL reference I have found, much more helpful than the online help. It is has not been a "waste of time" or "beginner level at best" for me. I have learned quite a bit about SQL from this book and I thought I was fairly knowledgeable before I read it.
Others in my department have also purchased this book and it has become the standard reference many of us use to answer SQL questions. If you are looking for a practical reference to common and advanced questions, you will find this book very useful.
Comment 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
36 of 41 people found the following review helpful By A Customer on December 20, 2000
Format: Paperback
One of the problems with a lot of computer books these days is that they try to cover a wide range of topics without _really_ delving into anything. This is one such book. It will tell you what a stored procedure is, how to code it, what some of the syntax is - the basics - without really going into the details. In other words, you won't learn anything from this book that you couldn't learn on your own in an afternoon with the Books Online and Query Analyzer. The SQL presented in this book is neither advanced nor SQL Server 2K specific, and I think you'd be wasting your money to buy it.
Comment 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
18 of 19 people found the following review helpful By "sql3642" on July 2, 2002
Format: Paperback
I have been writing SQL for a few years, and I have almost every book on TSQL. When I glanced over this book, I thought it was pretty good, but I waited until I saw the reviews on Amazon.com to get a second opinion. As the reviews were mostly negative, I did not buy the book back then.
Then some time later and with some spare money in hand, I got to the bookstore and this was the ONLY book on TSQL that I did not already own. So I caved in and bought it. This was a very wise move! The help given to me by this book has made it a more than worthwhile investement. I have over 10 SQL servers and have to maintain and write code for all of them. This books has been extraordinary help.
I you know very little of SQL, do not buy this book, get an intro book instead. But if you have "some" experience with SQL, then this is a great book to get deeper into TSQL. I will change the way you write code and make you a better TSQL developer.
Which leads me to wonder about the SQL capabilities of the writers of those negative reviews.... hum ;-)
Comment 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
13 of 13 people found the following review helpful By Mark K. Mcdonough VINE VOICE on November 15, 2001
Format: Paperback
In reading through the many reviews on this book, I notice that we have a bi-modal distribution. Intermediate users love it, and truly advanced users give it low marks.
The sub-title on the back cover is a better clue to what this book is about than the title -- "Practical T-SQL Solutions to Common Problems."
If you've sorted through your initial newbie issues about SQL and SQL Server and want to take your skills to the next level, you will find this book extremely worthwhile. If you're already an advanced T-SQL type looking for deeper insights, you'll probably be dissapointed.
Comment 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
13 of 13 people found the following review helpful By Karaszi Tibor on August 23, 2001
Format: Paperback
I think it is great that we have a book devoted to the relational parts of the TSQL language, but not diving too much into the technical aspects of TSQL (like system stored procedures etc). This is a programming book, for those who wish to take their TSQL knowledge a step further. Perhaps not as advanced as the title suggets, but a great book for anyone at the intermediate level. Also, the book does cover some more advanced topics like dynamic order by, handling hierarchies etc. One of the books on my recommendation list!
Comment 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
12 of 12 people found the following review helpful By street on January 25, 2001
Format: Paperback
If you've read Rob Viera's book, Professional SQL 7/2000 Programming, then your ready for this one. This book reads like a FAQ for common problems and solutions posted to the various listserves and newsgroups for SQL Server.
No, this book is not as advanced as many people (myself included) would have liked. Yes, there are a few parts that are poorly written. The honest truth is that this is not the book I had hoped it would be, but the TSQL community has needed a book like this for a while - not the bare basics, but not too advanced. It's certainly better than the one and two star ratings its been given by other readers. When your finished with this one, check out Henderson's Guru's Guide to TSQL.
Comment 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
12 of 12 people found the following review helpful By M. Stanley on January 4, 2001
Format: Paperback
This book has lots of worked problems and solutions. For example, the authors show how to remove duplicates, handle hierarchies, auditing, pivot tables, password encryption, case sensitive searches, opening a cursor on a stored proc call, doing your own sort order, etc. It would be nice to have the code on CD, instead of downloading.
Comment 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


More About the Author

Itzik Ben-Gan is a Mentor and Co-Founder of SolidQ. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including Microsoft SQL Server 2012 T-SQL Fundamentals and Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions. He has written many articles for SQL Server Pro as well as articles and whitepapers for MSDN. Itzik's speaking activities include TechEd, DevWeek, SQLPASS, SQL Server Magazine Connections, various user groups around the world, and SolidQ's events to name a few. Itzik is the author of SolidQ's Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities.
For more details please visit http://tsql.solidq.com.