Master your Minecraft
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    New Favorites | November 25, 2014

    Powell's Staff: IMG Our Favorite New Favorites of 2014



    Every week, we gather together a small pile of newly released titles that we agree should be on everyone's radar. We deem these titles our New... Continue »

    spacer

On Order

$59.95
New Trade Paper
Currently out of stock.
Add to Wishlist
Qty Store Section
- Local Warehouse Computer Languages- SQL

More copies of this ISBN

Advanced Transact-SQL For SQL Server 2000

by and

Advanced Transact-SQL For SQL Server 2000 Cover

 

Synopses & Reviews

Publisher Comments:

This book explores the powerful capabilities of T-SQL and helps you to exploit them to the max. The book tackles advanced areas in T-SQL such as joins, subqueries, stores procedures, triggers, user-defined functions, indexed views, cascading actions, federated views, hierarchial structures and more. The book shows solutions to common problems both in SQL server 2000 and in previous versions. Special emphasis is placed on practicular problems in the industry and on writing efficient and well performing code. The book does not stop at ANSI-92 SQL but also represents features that are particular to SQL Server, especially SQL Server 2000. To help you in your journey, the book provides many puzzles (and beware, these are not simple ones) and proposed solutions.About the authors:Itzik Ben-Gan is a senior SQL Server instructor and consultant with ten years of experience in networking, development, databases and data warehousing. He is a popular columnist and contributing editor for SQL Server Magazine, and is a Microsoft SQL Server MVP.Dr. Tom Moreau is President of Brockman Moreau Consulting, Inc. with more than sixteen years of professional experience in Information Technology. Moreau has been using SQL Server since 1993. He writes regularly for Pinnacle's Microsoft SQL Server Professional newsletter.

Synopsis:

Ben-Gan and Moreau explore the power capabilities of Transact-SQL. They offer solutions to common problems encountered using all versions of SQL Server with a focusing on the latest version, SQL Server 2000. Includes expert tips and real code examples.

Synopsis:

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.

Synopsis:

Provides hundreds of solutions to common problems encountered by SQL Server programmers.

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.

Product Details

ISBN:
9781893115828
Author:
Ben-Gan, Itzik
Author:
Moreau, Thomas
Author:
Moreau, Tom
Author:
Ben-Gan, Itzik
Author:
Ben-Gan, I.
Author:
Moreau, Thomas
Publisher:
Apress
Location:
Berkeley, CA
Subject:
Programming Languages - General
Subject:
Programming - General
Subject:
Programming Languages - SQL
Subject:
Client-server computing
Subject:
Database Management - SQL Server
Subject:
Sql server
Subject:
SQL
Subject:
Computer Languages-SQL
Edition Description:
New
Series:
Books for professionals by professionals
Series Volume:
2000-4
Publication Date:
20001131
Binding:
TRADE PAPER
Language:
English
Illustrations:
Yes
Pages:
864
Dimensions:
9.48x7.20x1.66 in. 3.04 lbs.

Other books you might like

  1. Essential SQL Server 2000: An... Used Trade Paper $5.95
  2. Multicast Sockets: Practical Guide... New Trade Paper $43.25
  3. Building Switched Networks:... New Trade Paper $45.50
  4. Client/server programming with Java... Used Trade Paper $5.95
  5. David McCarter's Essential VB Tips... New Trade Paper $27.95
  6. Transact-SQL Programming with CDROM Used Trade Paper $5.95

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Database » Applications
Computers and Internet » Database » Design
Computers and Internet » Software Engineering » Programming and Languages
Computers and Internet » Software Engineering » Software Management

Advanced Transact-SQL For SQL Server 2000 New Trade Paper
0 stars - 0 reviews
$59.95 Backorder
Product details 864 pages Apress - English 9781893115828 Reviews:
"Synopsis" by , Ben-Gan and Moreau explore the power capabilities of Transact-SQL. They offer solutions to common problems encountered using all versions of SQL Server with a focusing on the latest version, SQL Server 2000. Includes expert tips and real code examples.
"Synopsis" by , 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.

"Synopsis" by , Provides hundreds of solutions to common problems encountered by SQL Server programmers.
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.