Advanced Transact-SQL for SQL Server 2000

by Itzik Ben-Gan and Tom Moreau

Both authors regularly write articles for the two most important magazines in the SQL Server market: SQL Server Magazine and Microsoft SQL Server Professional. The authors paid special attention to practical needs and problems raised in SQL Server programming newsgroups. Numerous examples are provided throughtout each chapter. Puzzles are presented through the book to encourage the reader to apply skills learned to difficult problems.

• Format: Paperback
• Language: English
• ISBN: 1893115828
• ISBN13: 9781893115828
• Release Date: November 2000
• Publisher: Apress
• Length: 864 Pages
• Weight: 3.96 lbs.
• Dimensions: 1.7" x 7.2" x 9.5"

Customer Reviews

One of the Best TSQL books

I have followed Itzik Ben-Gan's columns in SQL Server Magazine and I found his articles addressing some of the trickier problems frequently faced by SQL developers. The solutions presented have almost always been very elegant and changed one's perspective of looking at a whole class of problems.This book is distilled from a lot of those very clever articles from SQL Server Magazine [and then some] and I heartily recommend this book to tickle your SQL senses. [I am very surprised with the number of negative reviews for this book, believe me, it does not deserve it].

Great book, definitely has its role

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!

I enjoy the book !

I am glad I got this book that I can learn so much from it. This book offers practical solutions with complete explanations. It has full of helpful examples of SQL scripts to explore to gain ideas on what to do and what not to do. I really like it.

I liked it

My friend showed me this book and I went out and got one. It's easy to understand and I like the full discussions of each example. It doesn't leave you hanging. They even compare the performance of different solutions and I like that. The new stuff for SQL Server seems to be well covered, though there is nothing on XML but it is supposed to be about Transact-SQL, so I guess that's OK. I picked up some tricks with derived tables that I have put to use. Chapter 16 on hierarchies was cool. It brought together the triggers and user-defined functions ideas in a practical problem.