Advanced Transact-SQL for SQL Server 2000

Itzik Ben-Gan, Tom Moreau

$116.95 $93.60

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

APress
19 June 2003

Computer hardware; Database programming; SQL Server & MS SQL

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.

By: Itzik Ben-Gan, Tom Moreau
Imprint: APress
Country of Publication: United States
Edition: Softcover reprint of the original 1st ed.
Dimensions: Height: 235mm, Width: 191mm, Spine: 42mm
Weight: 1.594kg
ISBN: 9781893115828
ISBN 10: 1893115828
Pages: 864
Publication Date: 19 June 2003
Audience: General/trade , ELT Advanced
Format: Paperback
Publisher's Status: Active

* Foreword * About the Authors * Preface * Introduction * Chapter 1: Joins in T-SQL * Chapter 2: Subqueries and Derived Tables * Chapter 3: Populating Tables * Chapter 4: Other Data Manipulation Issues * Chapter 5: Summarizing Data * Chapter 6: Special Datatypes and Properties * Chapter 7: Writing Code in T-SQL * Chapter 8: Views * Chapter 9: Stored Procedures * Chapter 10: Triggers -- The Hidden Stored Procedures * Chapter 11: User-Defined Functions * Chapter 12: Temporary Tables * Chapter 13: Horizontally Partitioned Views * Chapter 14: Implementing Referential Integrity and Cascading Actions * Chapter 15: Server-Side Cursors -- the SQL of Last Resort * Chapter 16: Expanding Hierarchies * Chapter 17: Tips and Tricks * Chapter 18: SQL Puzzle Solutions * Appendix A: DML Basics * Appendix B: Checking for ANSI Compatibility with SET FIPS_FLAGGER * Appendix C: Analyzing Query Performance * Appendix D: Ownership Chains * Appendix E: Pubs and Northwind Database Schemas * Appendix F: Dynamically Creating Triggers for Cascade Actions * Appendix G: References * Index

"Itzik Ben-Gan is a senior SQL Server instructor and consultant with 10 years of experience in networking, development, databases, and data warehousing. He is a popular columnist and contributing editor for SQL Server Magazine. Highly certified, he is also a Microsoft Certified Trainer (MCT), a Microsoft Certified Systems Engineer + Internet (MCSE+1), a Microsoft Certified Solution Developer (MCSD), a Microsoft Certified Database Administrator (MCDBA), and a Microsoft SQL Server ""Most Valuable Professional""."