Apress

Advanced Transact-SQL for SQL Server 2000

By Itzik Ben-Gan , Tom Moreau

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

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

Related Titles

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 about it. You will find any confirmed erratum below, so you can check if your concern has already been addressed.

* Required Fields

No errata are currently published