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 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., This thorough, hands-on reference for database developers and administrators delivers expert guidance on sophisticated uses of Transact-SQL (T-SQL)-one of the most familiar and powerful programming languages for SQL Server. Written by a T-SQL guru, this guide focuses on language features and how they are interpreted and processed by the SQL Server execution engine. You'll get in-depth coverage of the sophisticated uses of T-SQL, including triggers, user-defined functions, exception handling, and more. Includes extensive code samples, table examples, and logic puzzles to help database developers and administrators understand the intricacies and help promote mastery of T-SQL.