Advanced Transact-SQL for SQL Server 2000

Authors: Ben-Gan, Itzik, Moreau, Tom

Download source code

Buy this book

eBook $44.99
price for USA
  • ISBN 978-1-4302-0859-4
  • Digitally watermarked, DRM-free
  • Included format: PDF
  • ebooks can be used on all reading devices
  • Download immediately after purchase
Softcover $59.95
price for USA
  • ISBN 978-1-893115-82-8
  • Free shipping for individuals worldwide
  • This title is currently reprinting. You can pre-order your copy now.
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".

Table of contents (18 chapters)

Buy this book

eBook $44.99
price for USA
  • ISBN 978-1-4302-0859-4
  • Digitally watermarked, DRM-free
  • Included format: PDF
  • ebooks can be used on all reading devices
  • Download immediately after purchase
Softcover $59.95
price for USA
  • ISBN 978-1-893115-82-8
  • Free shipping for individuals worldwide
  • This title is currently reprinting. You can pre-order your copy now.

Services for this book

Loading...

Bibliographic Information

Bibliographic Information
Book Title
Advanced Transact-SQL for SQL Server 2000
Authors
Copyright
2000
Publisher
Apress
Copyright Holder
Itzik Ben-Gan and Tom Moreau
eBook ISBN
978-1-4302-0859-4
DOI
10.1007/978-1-4302-0859-4
Softcover ISBN
978-1-893115-82-8
Edition Number
1
Number of Pages
XLII, 864
Topics