文档介绍：ABC Amber CHM Converter Trial version,
Inside Microsoft SQL Server 2005: T-SQL Programming
byItzik Ben-Gan, Dejan SarkaandRoger Wolter
Microsoft Press 2006 (532 pages)
ISBN:0735621977
Written by a T-SQL guru, this thorough, hands-on reference for database developers and
administrators focuses on language features and how they are interpreted and processed
by the SQL Server execution engine.
Table of Contents
Inside Microsoft SQL Server 2005— T-SQL Programming
Foreword
Preface
Introduction
C h - Datatype-Related Problems, XML, and CLR UDTs
apt
er
1
C h - Temporary Tables and Table Variables
apt
er
2
C h - C ursors
apt
er
3
C h - Dynamic SQL
apt
er
4
C h - Views
apt
er
5
C h - User-Defined Functions
apt
er
6
C h - Stored Procedures
apt
er
7
C h - Triggers
apt
er
8
C h - Transactions
apt
er
9
C h - Exception Handling
apt
er
10
C h - Service Broker
apt
er
11
Ap - C ompanion to CLR Routines
pe
ndi
x A
Index
List of Figures
Page 1
ABC Amber CHM Converter Trial version,
List of Tables
List of Listings
List of Sidebars
Page 2
ABC Amber CHM Converter Trial version,
Back Cover
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 language
features and how they are interpreted and processed by the SQL Server execution engine. You’ll get
in-depth coverage of the sophisticated uses of T-SQL, including triggers, user-defined functions,
exception handling, and more. The book explains pares solutions to database-development
problems in both SQL Server 2000 and SQL Server 2005, discussing the new T-SQL programming
features added to SQL Server 2005 in detail. Includes extensive code sam