عنوان
پدید آورنده
موضوع
رده
QA76.73.S67 B46 2000b
QA76
.
73
.
S67
B46
2000b
کتابخانه
محل استقرار
INTERNATIONAL STANDARD BOOK NUMBER
(Number (ISBN
1430208597
(Number (ISBN
9781430208594
Erroneous ISBN
1893115828
Erroneous ISBN
9781893115828
NATIONAL BIBLIOGRAPHY NUMBER
Number
b767164
TITLE AND STATEMENT OF RESPONSIBILITY
Title Proper
Advanced Transact-SQL for SQL Server 2000 /
General Material Designation
[Book]
First Statement of Responsibility
Itzik Ben-Gan and Tom Moreau.
EDITION STATEMENT
Edition Statement
1st ed.
.PUBLICATION, DISTRIBUTION, ETC
Place of Publication, Distribution, etc.
Berkeley, Calif. :
Name of Publisher, Distributor, etc.
Apress,
Date of Publication, Distribution, etc.
©2000.
PHYSICAL DESCRIPTION
Specific Material Designation and Extent of Item
1 online resource (xlii, 814 pages) :
Other Physical Details
illustrations
SERIES
Series Title
Books for professionals by professionals
GENERAL NOTES
Text of Note
Includes index.
Text of Note
Title from title screen.
INTERNAL BIBLIOGRAPHIES/INDEXES NOTE
Text of Note
Includes bibliographical references (pages 795-798) and index.
CONTENTS NOTE
Text of Note
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.
0
SUMMARY OR ABSTRACT
Text of Note
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.
SYSTEM REQUIREMENTS NOTE (ELECTRONIC RESOURCES)
Text of Note
Master and use copy. Digital master created according to Benchmark for Faithful Digital Reproductions of Monographs and Serials, Version 1. Digital Library Federation, December 2002.
ACQUISITION INFORMATION NOTE
Stock Number
itpro
OTHER EDITION IN ANOTHER MEDIUM
Title
Advanced transact-SQL for SQL server 2000.
International Standard Book Number
9781893115828
TITLE USED AS SUBJECT
SQL server.
SQL server.
TOPICAL NAME USED AS SUBJECT
Database management.
SQL (Computer program language)
Database management.
SQL (Computer program language)
(SUBJECT CATEGORY (Provisional
COM051230
UL
UMT
UMZ
UN
DEWEY DECIMAL CLASSIFICATION
Number
005
.
75/6
Edition
21
LIBRARY OF CONGRESS CLASSIFICATION
Class number
QA76
.
73
.
S67
Book number
B46
2000b
PERSONAL NAME - PRIMARY RESPONSIBILITY
Ben-Gan, Itzik.
PERSONAL NAME - ALTERNATIVE RESPONSIBILITY
Moreau, Tom.
ORIGINATING SOURCE
Date of Transaction
20201206122128.0
Cataloguing Rules (Descriptive Conventions))
pn
ELECTRONIC LOCATION AND ACCESS
Electronic name
مطالعه متن کتاب [Book]
Y
