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.

Sample Content

Table of Contents

• Dedication
• Foreword
• Acknowledgments
• Introduction
• Chapter 1: Views
• Chapter 2: User-Defined Functions
• Chapter 3: Stored Procedures
• Chapter 4: Triggers
• Chapter 5: Transactions and Concurrency
• Chapter 6: Error Handling
• Chapter 7: Temporary Tables and Table Variables
• Chapter 8: Cursors
• Chapter 9: Dynamic SQL
• Chapter 10: Working with Date and Time
• Chapter 11: CLR User-Defined Types
• Chapter 12: Temporal Support in the Relational Model
• Chapter 13: XML and XQuery
• Chapter 14: Spatial Data
• Chapter 15: Tracking Access and Changes to Data
• Chapter 16: Service Broker
• Companion to CLR Routines
• About the Authors

Updates

Submit Errata