Loading…

Inside Microsoft SQL server 2005 : T-SQL querying /

This thorough, hands-on reference for database developers and administrators delivers expert guidance on sophisticated uses of Transact-SQL (T-SQL) - one of the most familiar and powerful programming languages for SQL Server. Written by a T-SQL guru, this guide focuses on advanced querying technique...

Full description

Bibliographic Details
Call Number:Libro Electrónico
Main Author: Ben-Gan, Itzik
Other Authors: Kollar, Lubor, Sarka, Dejan
Format: Electronic eBook
Language:Inglés
Published: Redmond, Wash. : Microsoft Press, ©2006.
Subjects:
Online Access:Texto completo (Requiere registro previo con correo institucional)
Table of Contents:
  • 1. Logical query processing
  • 2. Physical query processing
  • 3. Query tuning
  • 4. Subqueries, table expressions, and ranking functions
  • 5. Joins and set operations
  • 6. Aggregating and pivoting data
  • 7. TOP and APPLY
  • 8. Data modification
  • 9. Graphs, trees, hierarchies, and recursive queries
  • A. Logic puzzles.