 |
Advanced Transact-SQL for SQL Server 2000
Customer Reviews: 1 Average Customer Rating:  Write a Review and tell the world about this title! People who purchase this book frequently purchase: - Guru's Guide to SQL Server Stored Procedures, XML, and HTML; Ken Henderson, $40.95, 37% Off!
- Inside Microsoft SQL Server 2000; Kalen Delaney, $37.50, 37% Off!
- Mastering SQL Server 2000; Mike Gunderloy, $31.50, 37% Off!
- Microsoft SQL Server 2000 Performance Tuning Technical Reference; Steve Adrien DeLuca, et al, $30.95, 38% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
- Expert tips and real code examples teach advanced database programmers to
write more efficient and
better-performing code that takes full advantage of Transact SQL
- Provides hundreds of solutions to common problems encountered by SQL Server
programmers
In Advanced Transact-SQL for SQL Server 2000, Itzik Ben-Gan and Dr. Tom Moreau
explore the
powerful capabilities of Transact-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. The
authors offer practical solutions to the everyday problems programmers face
and provide significant content
on the advanced areas in T-SQL such as joins,subqueries, stored procedures,
triggers, user-defined functions
(UDFs), indexed views, cascading actions, federated views, hierarchical structures,
cursors and more.
Table of Contents
Joins
in T-SQL
Subqueries
and Derived Tables
Populating
Tables
Other
Data Manipulation Issues
Summarizing
Data
Special
Datatypes and Properties
Writing
Code in T-SQL
Views
Stored
Procedures
Triggers
User-Defined
Functions
Working
with Temporary Tables
Horizontally
Partitioned Views
Implementing
Cascading Operations
Working
with Cursors
Expanding
Hierarchies
Tips
& Tricks
Customer Reviews
Customer Reviews: 1 Average Customer Rating: Apr 21, 2004
excellent sql reference
I'm surprised nobody has written a review for this book so far. The contents of the book cover exactly what the book is entitled. Examples are clear and explanatory and help you distinguish how similar items in SQL Server actually work. I've referred to this book so much it's one of the few books that has started actually falling apart on me.
|
|
