Inside Microsoft SQL Server 2008: T-SQL Programming

Description

Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of this programming language - solving complex problems with real-world solutions.

Discover how to:

* Work with T-SQL and CLR user-defined functions, stored procedures, and triggers.
* Handle transactions, concurrency, and error handling.
* Efficiently use temporary objects, including temporary tables, table variables, and table expressions.
* Evaluate when to use set-based programming techniques and when to use cursors.
* Work with dynamic SQL in an efficient and secure manner.
* Treat date- and time-related data in a robust manner.
* Develop CLR user-defined types and learn about temporal support in the relational model.
* Use XML and XQuery and implement a dynamic schema solution.
* Work with spatial data using the new geometry and geography types and spatial indexes.
* Track access and changes to data using extended events, SQL Server Audit, change tracking, and change data capture.
* Use Service Broker for controlled asynchronous processing in database applications.

All the book’s code samples will be available for download from the companion Web site.

CONTENTS:

DedicationForewordAcknowledgmentsIntroductionChapter 1: ViewsChapter 2: User-Defined FunctionsChapter 3: Stored ProceduresChapter 4: TriggersChapter 5: Transactions and ConcurrencyChapter 6: Error HandlingChapter 7: Temporary Tables and Table VariablesChapter 8: CursorsChapter 9: Dynamic SQLChapter 10: Working with Date and TimeChapter 11: CLR User-Defined TypesChapter 12: Temporal Support in the Relational ModelChapter 13: XML and XQueryChapter 14: Spatial DataChapter 15: Tracking Access and Changes to DataChapter 16: Service BrokerCompanion to CLR RoutinesAbout the Authors