25 used & new from $1.65

Have one to sell? Sell yours here

Tell the Publisher! I�d like to read this book on Kindle Don�t have a Kindle? Get your Kindle here.

Transact-SQL Programming (Paperback)

~ Lee Gould (Author), Andrew Zanevsky (Author), Kevin Kline (Author)

2.7 out of 5 stars See all reviews (101 customer reviews)

Available from these sellers.

5 new from $34.99 20 used from $1.65

Like this book? Find similar titles from O'Reilly and Partners in our O'Reilly Bookstore.

› See more product promotions

Customers Who Bought This Item Also Bought

The Guru's Guide to Transact-SQL

by Ken Henderson

4.7 out of 5 stars (238) $44.16

Transact-SQL Cookbook

by Ale peti

3.4 out of 5 stars (14) $31.29

SYBASE TRANSACT SQL GUIDELINES BEST PRACTICES

by Mich Talebzadeh

4.5 out of 5 stars (15) $40.50

Beginning Transact-SQL With SQL Server 2000 and 2005

by Paul Turley

4.0 out of 5 stars (4) $26.39

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

by Lubor Kollar

4.7 out of 5 stars (31) $29.69

› Explore similar items

Editorial Reviews

Product Description

This definitive guide thoroughly explores all aspects of Transact-SQL, a full-featured procedural language used on both Microsoft SQL Server and Sybase SQL Server systems that dramatically extends the power of SQL (Structured Query Language). Full of examples, best practices, and real-world advice, it contains up-to-the-minute information on the latest versions: Microsoft SQL Server versions 6.5 and 7.0 and Sybase version 11.5. The book is divided into six convenient parts. Part I contains an introduction, an SQL primer, and chapters on language fundamentals, format, and style. Part II describes datatypes and variables, conditional processing, cursors, error handling, temporary objects, transactions, and locking. Part III covers the various types of functions available to programmers and CASE extensions to the language. Part IV discusses stored procedures and modular design, triggers, views, extended stored procedures, and BCP. Part V describes code design and maintenance, optimization, tuning, transactions, locking, testing, and debugging. The appendixes summarize system tables and version differences. The enclosed CD-ROM contains an extensive set of examples from the book and complete programs that illustrate the power of the language.

About the Author

Lee Gould is a principal consultant with Sybase Professional Services in New York where she works mainly in the financial services industry on Wall Street. She has been working with SQL Server since 1992 and has been involved in the computer industry for over ten years. She has published numerous articles in Microsoft SQL Server Professional (Pinnacle Publishing) and presented on a variety of topics at the International Sybase User Group and Powersoft conferences. Lee was born in Liverpool, England. She grew up in Johannesburg, South Africa, where she attended the University of Witwatersrand and received her bachelors of commerce in business information systems. Lee immigrated to America four years ago and is currently pursuing an MBA at Seton Hall University in New Jersey. Lee lives in the suburb of North Brunswick, New Jersey, with her two cats, Lady and Paganini. She can often be seen running, cycling, swimming, and horseriding while she trains for marathons and ultra triathlon events. When not immersed in sport, Lee is an avid fan of classical music, good wine, the piano, science fiction and Terminator II. Her motto on life is "carpe diem," which she endeavors to follow regardless of where it leads her. Lee can be contacted at lee_k_gould@yahoo.com.

Andrew Zanevsky, an independent consultant and founder and president of AZ Databases, Inc., has been working with SQL Server since 1992. He writes a monthly column "Super Administrator," for Microsoft SQL Server Professional (Pinnacle Publishing) and has published more than a hundred technical articles throughout his career. He immigrated to the United States from Minsk, Belarus in 1991. He started programming in 1982 and holds a degree from the Belarus State University of Informatics and Radioelectronics (equivalent to an M.S. in computer science). Andrew lives in a suburb of Chicago with his wife Katrin, son Anthony, and stepdaughter Esther. Katrin is also a SQL Server consultant. They work on some projects together and can talk about Transact-SQL at dinner. Andrew's daughter Nikkie lives in New York, wants to be a writer, and has won numerous awards in art contests. Andrew was the president of the Great Lakes SQL Server Users Group in Chicago from 1994 through 1997. He can be reached at zanevsky@azdatabases.com.

Product Details

Paperback: 836 pages
Publisher: O'Reilly Media, Inc. (April 1, 1999)
Language: English
ISBN-10: 1565924010
ISBN-13: 978-1565924017
Product Dimensions: 9.2 x 7 x 1.6 inches
Shipping Weight: 2.6 pounds

Average Customer Review: 2.7 out of 5 stars See all reviews (101 customer reviews)

Amazon.com Sales Rank: #154,218 in Books (See Bestsellers in Books)
Popular in these categories: (What's this?)
#47 in Books > Computers & Internet > Databases > Relational Databases
#61 in Books > Computers & Internet > Microsoft > Development > SQL Server

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

More About the Author

Discover books, learn about writers, read author blogs, and more.

› Visit Amazon's Kevin E. Kline Page

Look Inside This Book

Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover

Citations (learn more)

2 books cite this book:

Applied Perl by Peter Williams on page 206
Developing Killer Web Apps with Dreamweaver MX and C# by Chuck White on page 39

What Do Customers Ultimately Buy After Viewing This Item?

	73% buy the item featured on this page: Transact-SQL Programming 2.7 out of 5 stars (101)
	7% buy Transact-SQL Cookbook 3.4 out of 5 stars (14) $31.29
	6% buy Pro T-SQL 2005 Programmer's Guide (Expert's Voice) 4.8 out of 5 stars (6) $31.49
	5% buy Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes 4.3 out of 5 stars (6) $13.59

Explore similar items

Tags Customers Associate with This Product

(What's this?)

Click on a tag to find related items, discussions, and people.

programming(3)

book - computer - database(2)

database(2)

reference(1)

work(1)

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

Customer Reviews

101 Reviews

5 star:		(31)
4 star:		(10)
3 star:		(3)
2 star:		(12)
1 star:		(45)

Average Customer Review

2.7 out of 5 stars (101 customer reviews)

Share your thoughts with other customers:

Create your own review

Most Helpful Customer Reviews

17 of 17 people found the following review helpful:

5.0 out of 5 stars A purist's T-SQL book., February 29, 2000

By	Kevin Tsai "kekezinho" (Oakland, CA United States) - See all my reviews (REAL NAME)

You'd think this book covers SQL Server 6.5, 7.0 and Sybase SQL Server that this is going to be patchy here and there, trying to cover one product here and another product there. You'd think SQL Server 7.0 is so much more advanced than SQL Server 6.5 that this book has to make so many compromises that it's only half good for either. And you'd probably think that this book has so few pages, this must only be an intro.

Not so on all three accounts. This book is to-the-point Transact-SQL. There's no filler material here. I've programmed in Transact-SQL for quite awhile, and the examples, along with the descriptions, help me produce clean code. SQL Server is sensitive to how code and indexes interact. The author stresses the synergistic design of indexes and code.

Here is what you do have to watch out for if you're considering this book:

*This book is clearly a T-SQL only book. For example, it does not dwell on the exact page size; 6.5 uses 2k pages, while 7.0 uses 8k pages. You must be aware of this when you code and design indexes. This book covers the concepts very well, but it is up to you to apply the concepts to your design.

*Certain exciting additions such as Linked Servers are not discussed. The book is a bit backwards on the inter-operability of SQL Server, since Linked Server offers remote queries in addition to the functionality of Remote Servers (Linked Server is not available in 6.5).

*Replication is also not discussed. SQL Server 7.0 has greatly improved on the replication capabilities over 6.5, both in ease and reliability. In all fairness, replication is an enterprise architecture issue more than a coding issue.

Like all thick products, SQL Server (and Sybase SQL Server) deserves more than one book on any developer's/DBA's desk. I really like this book as a coding guide, but would definitely supplement this with:

*Inside SQL Server 7.0: performance tuning and deep understanding of SQL Server under-the-hood. This book is hard core.

*Books Online: excellent coverage on Replication, DTC, disaster recovery. Although not nice to read, I've had a hard time finding this information elsewhere.

*Deploying SQL Server: high level deployment guide.

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

9 of 9 people found the following review helpful:

5.0 out of 5 stars 6.5 or 7.0 - doesn't matter!, October 19, 1999

By	Morris (Nashville, Tennessee) - See all my reviews

T-SQL hasn't changed so much in 7.0 that its users cannot get a lot of useful information out of this book. For 6.5 DBA's, it is a *MUST* have book, no matter what your skill level.

Don't let the people who whine about it being focussed more on 6.5 than 7.0 scare you away. These people are obviously not managing real database installations because most of the professional DBA's I know (me included) are still managing 6.5 servers and will be throughout most of next year.

Buy this book if you want to be a DBA worth your paycheck.

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

12 of 13 people found the following review helpful:

2.0 out of 5 stars Good, but very specific to 6.5, March 23, 2000

By A Customer

I liked this book, but SQL 7.0 is covered in an appendix. Moreover, many of the techniques shown are archaic and have been deprecated by Microsoft, even for SQL 6.5. For example, joins are often show using the old join syntax. I wouldn't have such a problem with this if this book didn't advertise itself as a SQL 7.0 book. It's definitely not a 7.0 book and if you buy it expecting that, you'll be disappointed. Another problem with the book is its failure to adequately distinguish between Sybase and Microsoft syntax. There are some important differences, as the products have diverged more with each new release. Some of the examples show code that works on Sybase, but not on Microsoft (or vice versa), without telling the reader. The book would have been better off focusing on one or the other.

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 101 customer reviews...

Most Recent Customer Reviews

5.0 out of 5 stars Great T-SQl reference when working on older systems
I use this for reference while working on Sybase 11.9.2. It's an excellent in-depth book. Includes basic SQL through procs and cursors to detailed tuning information. Read more

Published on October 10, 2007 by Alec Permison

5.0 out of 5 stars "The Bible"
This is the bible for Sybase developer. I actually never finished reading this book cover to cover(tried few times but failed and gave up eventually) due to its rather dry... Read more

Published on February 15, 2007 by YongSung Kim

5.0 out of 5 stars Still quite relevant for Sybase developers
Although there aren't too many Sybase databases anymore, quite a few firms (esp. in Finance) have them and if you find yourself working with Sybase I strongly recommend this book... Read more

Published on July 13, 2006 by Frank J. Kelly

5.0 out of 5 stars Good resource for T-SQL information
I purchased my copy back in 1999 and it is one of my favorite SQL books. I find the information very accurate and relevant to the MS SQL versions (6.5 & 7. Read more

Published on August 4, 2005 by Salomon Young

5.0 out of 5 stars Good book with easy-to-find answers to your questions
Judging from the other reviews here, people either love this book or they hate it. I love it. This book has proved invaluable to me over the years, and I still reference it on... Read more

Published on July 8, 2005 by Alan Hummel

5.0 out of 5 stars I liked it
This is a comprehensive book.
Full of practical advice. The author(s) apparently has a lot of experience as a developer. Read more

Published on August 24, 2004 by O. Koblauch

1.0 out of 5 stars A poor copy of books online
Anyone can copy information from other sources and put it into a book. It takes someone who really knows his or her stuff to write a book that is invaluable to the SQL programmer... Read more

Published on August 18, 2003 by Chad

5.0 out of 5 stars Great Sybase and Microsoft SQL Server reference
I've owned this book for over two years and I still go back to it as a reference. It covers Sybase SQL Server 11.5 and Microsoft SQL Server 6.5 (with limitted coverage of 7. Read more

Published on August 28, 2002 by E Isaacs

1.0 out of 5 stars A Great Door Stop!
Our teacher chose this never ending phone book for the relatively simple language of SQL (not Transact SQL)! Read more

Published on July 19, 2002

1.0 out of 5 stars Buyer Beware: Book is out of date
AS so many others have said, this book was out of date when it was published. Not a good sign. Computer books are by their very nature very time sensitive. Read more

Published on March 16, 2002

› See all 101 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; }