Advanced Transact-SQL for SQL Server 2000

Ben-Gan, Itzik; Moreau, Tom

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.

Details

Published by: Apress

Publication Date: 2000-11-28

Format: Paperback

ISBN-13: 9781893115828

DOI: 10.1007/978-1-4302-0859-4

Dimensions: 235cm x191cm

Pages: 864