Get 1 Year of unlimited Apress for $199
Instant access to all available titles and new releases Apress Access Subscription

Advanced Transact-SQL for SQL Server 2000

By Itzik Ben-Gan , Tom Moreau

  • eBook Price: $41.99
Buy eBook Buy Print Book

Advanced Transact-SQL for SQL Server 2000 Cover Image

This comprehensive reference provides expert tips and real code examples to teach advanced database programmers to write more efficient and better-performing code that takes full advantage of Transact-SQL (T-SQL).

Full Description

  • Add to Wishlist
  • ISBN13: 978-1-893115-82-8
  • 864 Pages
  • User Level: Beginner to Advanced
  • Publication Date: November 27, 2000
  • Available eBook Formats: PDF

Related Titles

  • Dynamic SQL
  • Pro Power BI Desktop
  • Practical Maintenance Plans in SQL Server
  • Pro SQL Server on Microsoft Azure
  • SQL Server AlwaysOn Revealed
  • Expert Performance Indexing in SQL Server
Full 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.

Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.

Errata

If you think that you've found an error in this book, please let us know by emailing to editorial@apress.com . You will find any confirmed erratum below, so you can check if your concern has already been addressed.
No errata are currently published

Best-Sellers

    1. Pro SQL Server Wait Statistics

      $34.99

      View Book

    2. SQL Server T-SQL Recipes

      $41.99

      View Book

    3. Healthy SQL

      $38.99

      View Book

    4. Expert T-SQL Window Functions in SQL Server

      $17.99

      View Book