|
" Advanced Transact-SQL for SQL Server 2000 / "
Itzik Ben-Gan and Tom Moreau.
| Document Type
|
:
|
BL
|
| Record Number
|
:
|
1012794
|
| Doc. No
|
:
|
b767164
|
| Main Entry
|
:
|
Ben-Gan, Itzik.
|
| Title & Author
|
:
|
Advanced Transact-SQL for SQL Server 2000 /\ Itzik Ben-Gan and Tom Moreau.
|
| Edition Statement
|
:
|
1st ed.
|
| Publication Statement
|
:
|
Berkeley, Calif. :: Apress,, ©2000.
|
| Series Statement
|
:
|
Books for professionals by professionals
|
| Page. NO
|
:
|
1 online resource (xlii, 814 pages) :: illustrations
|
| ISBN
|
:
|
1430208597
|
|
|
:
|
: 9781430208594
|
|
|
:
|
1893115828
|
|
|
:
|
9781893115828
|
| Notes
|
:
|
Includes index.
|
|
|
:
|
Title from title screen.
|
| Bibliographies/Indexes
|
:
|
Includes bibliographical references (pages 795-798) and index.
|
| 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.
|
| Abstract
|
:
|
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.
|
| Subject
|
:
|
Database management.
|
| Subject
|
:
|
SQL (Computer program language)
|
| Subject
|
:
|
Database management.
|
| Subject
|
:
|
SQL (Computer program language)
|
| Subject
|
:
|
SQL server.
|
|
|
:
|
SQL server.
|
| Dewey Classification
|
:
|
005.75/6
|
| LC Classification
|
:
|
QA76.73.S67B46 2000b
|
| Added Entry
|
:
|
Moreau, Tom.
|
| |