Advanced Transact-SQL for SQL Server 2000

Ben-Gan Itzik

ISBN 10: 1893115828 / ISBN 13: 9781893115828

Published by Apress, Incorporated, 2000

About this Item

pp. xlii + 814.

Seller Inventory # 7591223

Bibliographic Details

• Title: Advanced Transact-SQL for SQL Server 2000
• Publisher: Apress, Incorporated
• Publication Date: 2000
• Language: English
• ISBN 10: 1893115828
• ISBN 13: 9781893115828
• Binding: Soft cover
• Condition: New

About this title

Synopsis

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 Author

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