|
Inside SQL Server 2005: T-SQL Programming
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 the programming language - solving complex problems with real-world solutions. Discover how to: *Understand when to apply
set-based programming techniques *Design and implement date and time-related XML and CLR datatypes *Use temporary objects, including temporary tables, table variables, and table expressions *Work with T-SQL and CLR user-defined functions, stored procedures, and triggers *Support user input-based queries and variable data with dynamic execution *Work with transactions and new exception handling constructs *Apply a concurrency model to support simultaneous users *Use Service Broker for controlled asynchronous processing in database applications This book includes code samples on the Web
CONTENTS:
Datatype related problms, XML, & CLR UDTs
Temporary tables
Cursors
Dynamic SQL
Views
User-Defined functions
Stored procedures
Triggers
Transactions
Exception handling
Service broker
|
