Published by: MICROSOFT PRESS
Author: Itzik Ben-Gan (Solid Quality Learning), Dejan Sarka; Roger Wolter
Number of pages: 506
Group: SQL - TRANSACT SQL
ISBN: 0735621977/9780735621978
User level: Programmer - Int/Adv
Objective: Reference
Date Published: May 2006
 RRP £30.99 Save 34%
  Our Price £20.45

In Stock

See the latest price and availability.

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