Advanced Transact-SQL for SQL Server 2000 / Edition 1

Advanced Transact-SQL for SQL Server 2000 / Edition 1

by Itzik Ben-Gan, Tom Moreau
     
 

ISBN-10: 1893115828

ISBN-13: 9781893115828

Pub. Date: 11/27/2000

Publisher: Apress

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

…  See more details below

Overview

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.

Product Details

ISBN-13:
9781893115828
Publisher:
Apress
Publication date:
11/27/2000
Edition description:
1st ed. 2000. Corr. 2nd printing 2003
Pages:
864
Product dimensions:
7.52(w) x 9.25(h) x 0.10(d)

Table of Contents

Joins in T-SQL.- Subqueries and derived tables.- Populating tables.- Other data manipulation issues.- Summarizing data.- Special datatypes and properties.- Writing code in T-SQL.- Views.- Stored procedures.- Triggers.- User-defined functions.- Working with temporary tables.- Horizontally partitioned views.- Implementing cascading operations.- Working with cursors.- Expanding hierarchies.- Tips & Tricks.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >