Inside Microsoft SQL Server 2005: T-SQL Programming (Solid Quality Learning)

Author: Roger - Itzik Ben-gan - Dejan Sarka - Roger Wolter - Itzik - Ben-Gan - Itzik; Sarka - Dejan; Wolter - Itzik Ben-gan; Dejan Sarka; Roger Wolter
ISBN 10: 0735621977
ISBN 13: 9780735621978
Edition: Edition Unstated
Release: 2006-06-14
Format: Paperback (544 pages)
List Price: $44.99
Tags: Computers & Internet, Software,
Buy This Book
More Details

Book 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 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.