Advanced Transact-SQL for SQL Server 2000

Ben-Gan, Itzik; Moreau, Tom

ISBN 10: 1893115828 / ISBN 13: 9781893115828

Published by APress, 2000

About this Item

In this title, the authors pay special attention to practical needs and problems raised in SQL Server programming newsgroups. Numerous examples are provided throughout each chapter. Puzzles are presented through the book to encourage the reader to apply skills learned to difficult problems. Num Pages: 906 pages, biography. BIC Classification: UK; UMT; UNSJ. Category: (G) General (US: Trade). Dimension: 235 x 191 x 42. Weight in Grams: 1379. . 2000. Softcover reprint of the original 1st ed. Paperback. . . . . Books ship from the US and Ireland.

Seller Inventory # V9781893115828

Bibliographic Details

• Title: Advanced Transact-SQL for SQL Server 2000
• Publisher: APress
• 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".