Pro T-SQL 2008 programmer's guide

Discussing new and existing features, SQL Server designer and administrator Michael Coles takes you on an expert guided tour of Transact SQL functionality in SQL Server 2008 in his book Pro T SQL 2008 Programmer s Guide. Fully functioning examples and downloadable source code bring Coles technically...

Full description

Bibliographic Details
Main Author: Coles, Michael
Format: eBook
Language:English
Published: Berkeley, CA Apres 2008
Series:The expert's voice in SQL server
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
Table of Contents:
  • Includes bibliographical references and index
  • Foundations of T-SQL; T-SQL 2008 New Features; Tools of the Trade; Procedural Code and CASE Expressions; User-Defined Functions; Stored Procedures; Triggers; Encryption; Common Table Expressions and Windowing Functions; Integrated Full-Text Search; XML; XQuery and XPath; Catalog Views and Dynamic Management Views; SQL CLR Programming; .NET Client Programming; Data Services; New T-SQL Features; Error Handling and Dynamic SQL; Performance Tuning