Inside Microsoft Sql Server 2005

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.