Skip to main content
SpringerLink
Log in
Apress

Advanced Transact-SQL for SQL Server 2000

  • Book
  • © 2000

Overview

Authors:
  1. Itzik Ben-Gan
    View author publications

    You can also search for this author in PubMed   Google Scholar

  2. Tom Moreau
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Provides hundreds of solutions to common problems encountered by SQL Server programmers

  • Both authors write regularly for SQL Server Magazine and Pinnacle Publishing's Microsoft SQL Server Professional newsletter

  • Includes expert tips and plenty of real code examples

  • Presents differences between SQL Server 2000 and version 6.X and 7.0

  • Includes supplementary material: sn.pub/extras

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 44.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 59.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (18 chapters)

  1. Front Matter

    Pages i-xlii
    Download chapter PDF

  2. Joins in T-SQL

    • Itzik Ben-Gan, Tom Moreau
    Pages 1-42

  3. Subqueries and Derived Tables

    • Itzik Ben-Gan, Tom Moreau
    Pages 43-79

  4. Populating Tables

    • Itzik Ben-Gan, Tom Moreau
    Pages 81-109

  5. Other Data Manipulation Issues

    • Itzik Ben-Gan, Tom Moreau
    Pages 111-159

  6. Summarizing Data

    • Itzik Ben-Gan, Tom Moreau
    Pages 161-196

  7. Special Datatypes and Properties

    • Itzik Ben-Gan, Tom Moreau
    Pages 197-232

  8. Writing Code in Transact-SQL

    • Itzik Ben-Gan, Tom Moreau
    Pages 233-259

  9. Views

    • Itzik Ben-Gan, Tom Moreau
    Pages 261-301

  10. Stored Procedures

    • Itzik Ben-Gan, Tom Moreau
    Pages 303-340

  11. Triggers-the Hidden Stored Procedures

    • Itzik Ben-Gan, Tom Moreau
    Pages 341-373

  12. User-Defined Functions

    • Itzik Ben-Gan, Tom Moreau
    Pages 375-433

  13. Temporary Tables

    • Itzik Ben-Gan, Tom Moreau
    Pages 435-458

  14. Horizontally Partitioned Views

    • Itzik Ben-Gan, Tom Moreau
    Pages 459-501

  15. Implementing Referential Integrity and Cascading Actions

    • Itzik Ben-Gan, Tom Moreau
    Pages 503-552

  16. Server-Side Cursors — the SQL of Last Resort

    • Itzik Ben-Gan, Tom Moreau
    Pages 553-577

  17. Expanding Hierarchies

    • Itzik Ben-Gan, Tom Moreau
    Pages 579-627

  18. Tips and Tricks

    • Itzik Ben-Gan, Tom Moreau
    Pages 629-670

  19. SQL Puzzle Solutions

    • Itzik Ben-Gan, Tom Moreau
    Pages 671-733

  20. Back Matter

    Pages 735-816
    Download chapter PDF
Back to top

Keywords

About this book

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.

About the authors

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

Bibliographic Information

  • Book Title: Advanced Transact-SQL for SQL Server 2000

  • Authors: Itzik Ben-Gan, Tom Moreau

  • DOI: https://doi.org/10.1007/978-1-4302-0859-4

  • Publisher: Apress Berkeley, CA

  • eBook Packages: Springer Book Archive

  • Copyright Information: Itzik Ben-Gan and Tom Moreau 2000

  • Softcover ISBN: 978-1-893115-82-8Published: 28 November 2000

  • eBook ISBN: 978-1-4302-0859-4Published: 01 January 2008

  • Edition Number: 1

  • Number of Pages: XLII, 864

  • Topics: Database Management, Software Engineering/Programming and Operating Systems

Publish with us

Policies and ethics

Back to top

Search

Navigation