The guru's guide to Transact-SQL

The Guru's Guide to Transact-SQL is an indispensable reference for anyone working with this database development language. The accompanying CD-ROM includes the complete set of code examples found in the book as well as a SQL programming environment that will speed the development of your own to...

Full description

Bibliographic Details
Main Author: Henderson, Ken
Format: eBook
Language:English
Published: Reading, Mass. Addison-Wesley 2000
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
Table of Contents:
  • Includes bibliographical references and index
  • Introductory Transact-SQL
  • Transact-SQL Data Type Nuances
  • Missing Values
  • DDL Insights
  • DML Insights
  • The Mighty Select Statement
  • Views
  • Statistical Functions
  • Runs and Sequences
  • Arrays
  • Sets
  • Hierarchies
  • Cursors
  • Transactions
  • Stored Procedures and Triggers
  • Transact-SQL Performance Tuning
  • Administrative Transact-SQL
  • Full-Text Search
  • OLE Automation
  • Undocumented T-SQL.