Advanced Transact-SQL for SQL Server 2000 and over 2 million other books are available for Amazon Kindle . Learn more
Buy Used
£0.98
+ £2.80 UK delivery
Used: Very Good | Details
Condition: Used: Very Good
Comment: This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See more of our deals.
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

Advanced Transact-SQL for SQL Server 2000 Paperback – 1 Oct 2000

7 customer reviews

See all 3 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
Paperback
"Please retry"
£30.76 £0.98

Special Offers and Product Promotions

  • Win a £5,000 Amazon.co.uk Gift Card for your child's school by voting for their favourite book. Learn more.
  • Prepare for the summer with our pick of the best selection for children (ages 0 - 12) across Amazon.co.uk.


Win a £5,000 Amazon.co.uk Gift Card and 30 Kindle E-readers for your child or pupil's school.
Vote for your child or pupil(s) favourite book(s) here to be in with a chance to win.

Product details

  • Paperback: 864 pages
  • Publisher: APress (1 Oct. 2000)
  • Language: English
  • ISBN-10: 1893115828
  • ISBN-13: 978-1893115828
  • Product Dimensions: 5.7 x 19 x 24.1 cm
  • Average Customer Review: 4.4 out of 5 stars  See all reviews (7 customer reviews)
  • Amazon Bestsellers Rank: 1,525,898 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Inside This Book

(Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

4.4 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

8 of 8 people found the following review helpful By Chris A on 9 July 2002
Format: Paperback Verified Purchase
I was deeply disappointed with the book. Personally I think a better title would have been "Elementary T-SQL for those who can't be bothered to read the documentation". It has a huge amount of padding, definitions of a lot of things that can be found in Books Online, many references to previous versions of SQL Server, even as far back as 4.2, many snippets of attempted humour and pretend 'business cases' which I found intensely irritating, and nowhere near enough on industrial-strength stuff such as query design and performance. There is some good material for the more experienced reader (I'd say 20% of the total), but you have to search for it, and it doesn't go into enough depth when you do find it.
If it were targeted at those with a lower level of experience and knowledge, however, I would have a very different view - for those who are a little way past "select * from table" and wanting to do stuff a bit more complicated, I'd say it was quite appropriate. There is a lot of information in its 800 pages, and it's arranged well. My issue is really that it doesn't "do what it says on the tin" enough for me.
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 13 people found the following review helpful By anthonysmall@cwcom.net on 9 Sept. 2001
Format: Paperback
I discovered this book when I was in the middle of writing a Sales Order Processing application using Microsoft SQL Server 7.0 and Microsoft Visual Basic 6. I scanned through the wealth of material in this book and I was able to adapt many of the techniques to the Sales Order application. The book applies to SQL Server 7.0 and SQL Server 2000. It is aimed primarily at developers as opposed to those performing solely administrative tasks.
It contains 20 chapters in just over 800 pages dealing with programming issues like Referential Integrity with Cascading Actions, Views, Stored Procedures, Triggers, Partitioning data using Views, Cursors etc. This book is not a rehash of the SQL Server Books OnLine. There are also 7 appendices in the book. One deals with Analyzing Query Performance, another with 'Dynamically Creating Triggers for Cascade Actions' and a 'References' appendix that is littered with good places to obtain more information about SQL Server.
There are a number of extra useful facilities. For example many chapters have a 'From the Trenches' section that provide snippets of information about situations taken from real-world projects. There are also a number of 'Best Practices' sections where the authors make usage statements based on their knowledge of SQL Server. I benefited specifically from the 'Tips and Tricks' chapter made up of submissions by people solving specific real-world problems. I certainly didn't know that it was possible to use a Case statement as part of a Join in the way it is used in one of the examples.
The book also contains a number of puzzles at the end of each chapter. I was deeply involved with the Sales Order Processing Application project and felt I was 'too busy' to study them. But that was a mistake for me.
Read more ›
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
1 of 1 people found the following review helpful By Gelder on 28 Mar. 2007
Format: Paperback
Excellent book and wrote in the way that all t-sql book should be, I hold a MCP in the devlopment of SQL Server 2000 and there is some excellent little tips in this book and I really deny anyone that says this book has not helped or tuned part of the working practice. This is not a book for the beginner but would not be overly useful for the extremly advanced user but for everyone else there is a major guarantee that it will teach you either a new aspect, method or trick for solving some SQL problem.
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
By The Evil Doctor VINE VOICE on 17 Aug. 2006
Format: Paperback Verified Purchase
I bought this book on recommendation from an online SQL Server forum, in the hope that it would teach me how to make sense of huge T-SQL statements. I am an intermediate user, having used SQL 2000 for about 18 months.

The great part about this book is that is focuses on problem-solving, providing a range of requirements that you may need to report on, and then offering the solutions for each. The T-SQL results are also shown, meaning you don't have to actually type out the T-SQL to see the end-result. The book has made me realise that huge T-SQL statements are just a bunch of small, simple statements, and aren't so scary after all.

There's also some great info on the occurrence of NULLs, and the unexpected things that can happen when NULLs are encountered in results.

This book is not for beginners, and advanced users will not get a lot out of it either. Also true is that a lot of the stuff is in Books Online. However, you only go into Books Online (or Google) if you know what you're looking for. This books contains all the stuff you didn't even know you should be aware of!

This book will teach the intermediate user how to improve on the stuff they've done in the past, and act as a great reference for when you've forgotten the best way to get at that data!
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


Feedback