Pro T-SQL 2008 Programmer's Guide

Cover -- Copyright -- Dedication -- Contents at a Glance -- TOC$Contents -- About the Author -- About the Technical Reviewer -- Acknowledgments -- Introduction -- CH$1 Foundations of T-SQL -- A Short History of T-SQL -- Imperative vs. Declarative Languages -- SQL Basics -- Statements -- Databases -- Transaction Logs -- Schemas -- Tables -- Views -- Indexes -- Stored Procedures -- User-Defined Functions -- SQL CLR Assemblies -- Elements of Style -- Whitespace -- Naming Conventions -- One Entry, One Exit -- Defensive Coding -- SQL-92 Syntax Outer Joins -- The SELECT * Statement -- Variable Initialization -- Summary -- CH$2 T-SQL 2008 New Features -- Productivity Enhancements -- The MERGE Statement -- New Data Types -- Date and Time Data Types -- The hierarchyid Data Type -- hierarchyid Methods -- Spatial Data Types -- Grouping Sets -- Other New Features -- Summary -- CH$3 Tools of the Trade -- SQL Server Management Studio -- SSMS Editing Options -- Context-Sensitive Help -- Graphical Query Execution Plans -- Project Management Features -- The Object Explorer -- The SQLCMD Utility -- Business Intelligence Development Studio -- SQL Profiler -- SQL Server Integration Services -- The Bulk Copy Program -- SQL Server 2008 Books Online -- The AdventureWorks Sample Database -- Summary -- CH$4 Procedural Code and CASE Expressions -- Three-Valued Logic -- Control-of-Flow Statements -- The BEGIN and END Keywords -- The IF...ELSE Statement -- The WHILE, BREAK, and CONTINUE Statements -- The GOTO Statement -- The WAITFOR Statement -- The RETURN Statement -- The TRY...CATCH Statement -- The CASE Expression -- The Simple CASE Expression -- The Searched CASE Expression -- CASE and Pivot Tables -- COALESCE and NULLIF -- Cursors -- Summary -- CH$5 User-Defined Functions -- Scalar Functions -- Recursion in Scalar User-Defined Functions -- Procedural Code in User-Defined Functions -- Multistatement Table-Valued Functions -- Inline Table-Valued Functions -- Restrictions on User-Defined Functions -- Nondeterministic Functions -- State of the Database -- Summary -- CH$6 Stored Procedures -- Introducing Stored Procedures -- Calling Stored Procedures -- Managing Stored Procedures -- Stored Procedures in Action -- Recursion in Stored Procedures -- Table-Valued Parameters -- Temporary Stored Procedures -- Recompilation and Caching -- Stored Procedure Statistics -- Parameter Sniffing -- Recompilation -- Summary -- CH$7 Triggers -- DML Triggers -- When to Use DML Triggers -- Auditing with DML Triggers -- Nested and Recursive Triggers -- The UPDATE and COLUMNS_UPDATED Functions -- Triggers on Views -- DDL Triggers -- Logon Triggers -- Summary -- CH$8 Encryption -- The Encryption Hierarchy -- Service Master Keys -- Database Master Keys -- Certificates -- Asymmetric Keys -- Symmetric Keys -- Encryption Without Keys -- Hashing Data -- Extensible Key Management -- Transparent Data Encryption -- Summary -- CH$9 Common Table Expressions and Windowing Functions -- Common Table Expressions -- Mult.