Quantity:

More Buying Choices

30 used & new from �4.93

Have one to sell? Sell yours here

Share your own customer images

Search inside this book

Advanced Transact-SQL for SQL Server 2000 (Paperback)

by Itzik; Moreau, Tom Ben-Gan (Author)

4.4 out of 5 stars See all reviews (7 customer reviews)

RRP:	�47.49
Price:	�45.12 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save:	�2.37 (5%)
	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

Usually dispatched within 1 to 3 weeks.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

15 new from �4.93 14 used from �4.93 1 collectible from �28.55

Frequently Bought Together

Customers Who Bought This Item Also Bought

Inside Microsoft® SQL Server™ 2000 (DV-MPS Inside)

by Kalen Delaney

5.0 out of 5 stars (6) �30.99

Inside Microsoft® SQL Server™ 2005: T-SQL Querying (Solid Quality Learning)

by Lubor Kollar, Dejan Sarka Itzik Ben-Gan (Solid Quality Learning)

4.9 out of 5 stars (11) �23.35

Inside SQL Server 2005: T-SQL Programming (Solid Quality Learning)

by Dejan Sarka; Roger Wolter Itzik Ben-Gan (Solid Quality Learning)

5.0 out of 5 stars (2) �20.08

› Explore similar items

Product details

Paperback: 814 pages
Publisher: APRESS (1 Dec 2000)
Language English
ISBN-10: 1893115828
ISBN-13: 978-1893115828
Product Dimensions: 22.8 x 18.6 x 5.4 cm

Average Customer Review: 4.4 out of 5 stars See all reviews (7 customer reviews)

Amazon.co.uk Sales Rank: 360,459 in Books (See Bestsellers in Books)
Popular in this category:
#32 in Books > Computing & Internet > Databases > Applications > Microsoft SQL Server > Advanced & Intermediate

Would you like to update product info or give feedback on images?

See Complete Table of Contents

Customers Viewing This Page May Be Interested in These Sponsored Links

(What is this?)

Sql Server 2000 opens new browser window

www.rackspace.co.uk/databasehosting - Fast, secure SQL hosting. Award winning support 24/7.

Write Better Transact SQL opens new browser window

Red-Gate.com/Transact SQL - SQL Prompt™ completes and formats your T-SQL code. Free 14-day trial.

Dell - Server Offers opens new browser window

www.Dell.com/uk - Save On Dell Servers With Intel� Xeon�. Go Online & Get A Quote!

Product Description

In Advanced Transact-SQL for SQL Server 2000, authors Itzik Ben-Gan and Thomas Moreau explore the powerful capabilities of Transact-SQL (T-SQL). Ben-Gan and Moreau offer solutions to common problems encountered using all versions of SQL Server, with a focus on the latest version, SQL Server 2000. Expert tips and real code examples teach advanced database programmers to write more efficient and better-performing code that takes full advantage of T-SQL. The authors offer practical solutions to the everyday problems programmers face and include in-depth information on advanced T-SQL topics such as joins, subqueries, stored procedures, triggers, user-defined functions (UDFs), indexed views, cascading actions, federated views, hierarchical structures, cursors, and more.

Inside This Book (Learn More)

Tag this product

(What's this?)

Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items.

What Do Customers Ultimately Buy After Viewing This Item?

	64% buy the item featured on this page: Advanced Transact-SQL for SQL Server 2000 4.4 out of 5 stars (7) �45.12
	21% buy Inside Microsoft® SQL Server™ 2000 (DV-MPS Inside) 5.0 out of 5 stars (6) �30.99
	10% buy Professional SQL Server 2000 Programming (Programmer to Programmer) 5.0 out of 5 stars (10) �39.09
	4% buy Sams Teach Yourself Transact-SQL in 21 Days 4.7 out of 5 stars (19) �14.49

Explore similar items

Customer Reviews

7 Reviews

5 star:		(5)
4 star:		(1)
3 star:		(0)
2 star:		(1)
1 star:		(0)

Average Customer Review

4.4 out of 5 stars (7 customer reviews)

Share your thoughts with other customers:

Create your own review

Most Helpful Customer Reviews

8 of 8 people found the following review helpful:

2.0 out of 5 stars Doesn't match up to its title, 9 Jul 2002

By	Chris Aucken (London, England) - See all my reviews

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 Comment | Permalink | Was this review helpful to you? Yes No (Report this)

12 of 13 people found the following review helpful:

5.0 out of 5 stars A very useful piece of work and set to become a classic, 9 Sep 2001

By	anthonysmall@cwcom.net (London) - See all my reviews

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. I took some time off work and during that time found that the puzzle solutions offered me the opportunity to apply T-SQL to my application as opposed to just learning/reading the mechanics of T-SQL.

If you want to broaden your horizons read and attempt the solutions to these puzzles. The actual solutions to the puzzles are provided in a separate chapter.

Some of these puzzles require mental gymnastics but then that is why the book has the word 'Advanced' in its title!

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

1 of 1 people found the following review helpful:

5.0 out of 5 stars Excellent well Recommend, 28 Mar 2007

By	Gelder (Burnley, Lancashire) - See all my reviews (REAL NAME)

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 Comment | Permalink | Was this review helpful to you? Yes No (Report this)

Share your thoughts with other customers: Create your own review

› See all 7 customer reviews...

Most Recent Customer Reviews

4.0 out of 5 stars For intermediate users
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. Read more

Published on 17 Aug 2006 by Rouchie

5.0 out of 5 stars Excellent: I learned a lot from the word go
I took a gamble on ordering this one. I wanted a book which was solely SQL and not page on page of screenshots, but had never seen it in a bookshop. Read more

Published on 12 Mar 2004 by rjobrien2

5.0 out of 5 stars To the point
As a programmer with faily good general knowledge of SQL 2000 and T-SQL I wanted a book that got straight to the point with T-SQL code, techniques and best practices, not an... Read more

Published on 14 Feb 2002 by shudson@clara.net

5.0 out of 5 stars Answers Galore...
I bought the book by accident and thank goodness I did. The book is well written and doesn't mess around spending page after page explaining how great SQL is. Read more

Published on 23 April 2001

› See all 7 customer reviews...

.jsOffDisplayBlock { display: block; } .jsOffDisplayInline { display: inline; } .jsOffVisibility { visibility: visible; } .jsOnDisplayBlock { display: none; } .jsOnDisplayNoneBlock { display: block; } .jsOnDisplayNoneInline { display: inline; } .jsOnDisplayInline { display: none; } .jsOnVisibility { visibility: hidden; } .jqOnDisplayBlock { display: none; } .jqOnDisplayInline { display: none; } .jqOnVisibility { visibility: hidden; } .jqOnDisplayNoneBlock { display: block; } .jqOnDisplayNoneInline { display: inline; }