Inside Microsoft 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 techniquesDesign and implement date and time-related XML and CLR datatypesUse temporary objects, including temporary tables, table variables, and table expressionsWork with T-SQL and CLR user-defined functions, stored procedures, and triggersSupport user input-based queries and variable data with dynamic executionWork with transactions and new exception handling constructsApply a concurrency model to support simultaneous usersUse Service Broker for controlled asynchronous processing in database applications This book includes code samples on the Web.