Transact-SQL Programming w/CD-ROM Microsoft SQL Server 6.5/7.0 & Sybase 11.5

807 pages. Table of Contents: The Basics: Programming in Transact-SQLIntroduction to Transact-SQLDatabase Analysis and DesignSQL PrimerTransact-SQL FundamentalsFormat and StyleThe Building Blocks: Transact-SQL Language ElementsDatatypes and VariablesConditional ProcessingRow Processing with CursorsError HandlingTemporary ObjectsTransactions and LockingFunctions and ExtensionsFunctionsCASE Expressions and Transact-SQL ExtensionsProgramming Transact-SQL ObjectsStored Procedures and Modular DesignTriggers and ConstraintsViewsSystem and Extended Stored ProceduresPerformance Tuning and OptimizationTransact-SQL Code DesignCode Maintenance in SQL ServerTransact-SQL Optimization and TuningDebugging Transact-SQL ProgramsAppendixes (box J)