Acknowledgements
Introduction
Chapter 1 T-SQL Language Reference Overview
Transact-SQL Syntax Conventions
Chapter 2 New and Enhanced Features in Transact-SQL
Chapter 3 T-SQL Data Types
Data Type Precedence
Collation Precedence
Precision,Scale,and Length
Data Type Synonyms
Chapter 4 T-SQL Operators
T-SQL Operator Overview
T-SQL Operator Reference
Chapter 5 Reserved Keywords
Chapter 6 T-SQL Globals
Chapter 7 T-SQL Functions
Chapter 8 T-SQL DBCC Statements
T-SQL DBCC Statements Overview
T-SQL DBCC Statements Reference
Chapter 9 T-SQL Reference
Constants
Index A Northwind Sample Database
Categories
Customers
CustomerCustomerDemo
customerDemographics
Employees
EmployeeTerritories
Order Details
Orders
Products
Region
Shippers
Suppliers
Territories
Index B Pubs Sample Database
authors
discounts
employee
jobs
pub_info
publishers
roysched
sales
stores
titleauthor
titles
Index C Index of T-SQL Programming Elements in Volume 5