- By: Itzik Ben-Gan , Tom Moreau
- ISBN10: 1-893115-82-8
- ISBN13: 978-1-893115-82-8
- 864 pp.
- Published Oct 2000
- eBook Price: $41.97
- Price: $59.95
Advanced Transact-SQL for SQL Server 2000
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.
Share & Bookmark
|
|
|
|
|
|
|
|
|
|
|
|
|
Author Information
Itzik Ben-Gan
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 MVP.
Tom Moreau
Tom Moreau, B.Sc., Ph.D., MCSE, MCDBA, is an independent consultant specializing in Microsoft SQL Server database administration, design, and implementation, based out of the Toronto area. Tom is an SQL Server MVP and writes the monthly "Dr. Tom's Workshop" column for Pinnacle Publishing's SQL Server Professional newsletter.