or
Sign in to turn on 1-Click ordering.
 
 
More Buying Choices
30 used & new from £4.93

Have one to sell? Sell yours here
 
   
Advanced Transact-SQL for SQL Server 2000
 
 

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 buy this book with Inside Microsoft® SQL Server™ 2000 (DV-MPS Inside) by Kalen Delaney

Advanced Transact-SQL for SQL Server 2000 + Inside Microsoft® SQL Server™ 2000 (DV-MPS Inside)
Price For Both: £76.11

One of these items ships sooner than the other. Show details


Customers Who Bought This Item Also Bought

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

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)

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)

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
  • 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

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)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

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.
Your tags: Add your first tag
 

What Do Customers Ultimately Buy After Viewing This Item?


 

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:
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
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
 
 
 
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

Only search this product's reviews



Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

   


Listmania!


Look for similar items by category


Look for similar items by subject


Feedback

Ad

Your Recent History

 (What's this?)

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.