Inside Microsoft® SQL Server™ 2005

By: Dejan Sarka and Itzik Ben-Gan and Lubor Kollar

Sign Up Now! Already a Member? Log In
You must be logged into Bookshare to access this title. Learn about membership options, or view our freely available titles.

Synopsis: 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.