Advanced Transact-SQL for SQL Server 2000

Advanced Transact-SQL for SQL Server 2000

Paperback

By (author) Itzik Ben-Gan, By (author) Tom Moreau

USD$64.21
List price $73.20
You save $8.99 12% off

Free delivery worldwide
Available
Dispatched in 4 business days
When will my order arrive?

  • Publisher: aPress
  • Format: Paperback | 864 pages
  • Dimensions: 186mm x 228mm x 54mm | 1,742g
  • Publication date: 1 December 2000
  • Publication City/Country: Berkley
  • ISBN 10: 1893115828
  • ISBN 13: 9781893115828
  • Edition statement: New.
  • Sales rank: 1,960,483

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.

Other people who viewed this bought:

Showing items 1 to 10 of 10

Other books in this category

Showing items 1 to 11 of 11
Categories:

Author information

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".

Editorial reviews

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.

Table of contents

* 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