Advanced Transact-SQL for SQL Server 2000

Front Cover
Apress, 2000 - Computers - 814 pages
0 Reviews

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.

From inside the book

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Joins in TSQL
1
Cross Joins
11
Self and NonEqual Joins
28
Copyright

80 other sections not shown

Common terms and phrases

References to this book

About the author (2000)

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

Tom Moreau, Ph.D. is an MCSE, MCDBA, and independent consultant specializing in Microsoft SQL Server database administration, design, and implementation, based out of the Toronto area. Tom is an SQL Server "Most Valuable Professional" and writes the monthly "Dr. Tom's Workshop" column for Pinnacle Publishing's SQL Server Professional newsletter.

Bibliographic information