Author Description

<p>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.</p> <p><br> <br> Discover how to:<br></p> <ul> <li>Understand when to apply set-based programming techniques</li> <li>Design and implement date and time-related XML and CLR datatypes</li> <li>Use temporary objects, including temporary tables, table variables, and table expressions</li> <li>Work with T-SQL and CLR user-defined functions, stored procedures, and triggers</li> <li>Support user input-based queries and variable data with dynamic execution</li> <li>Work with transactions and new exception handling constructs</li> <li>Apply a concurrency model to support simultaneous users</li> <li>Use Service Broker for controlled asynchronous processing in database applications <br> <br> This book includes code samples on the Web. </li> </ul>