Inside Microsoft® SQL Server™ 2005: T-SQL Programming (Pro-developer)

Inside Microsoft® SQL Server™ 2005: T-SQL Programming (Pro-developer)

by Dejan Sarka (Author), Dejan Sarka (Author), Itzik Ben-Gan (Author), Lubor Kollar (Author)


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.


Save:$28.21 (81%)


1 in stock

More Information

Format: Paperback
Pages: 536
Edition: 1
Publisher: Microsoft Press
Published: 01 May 2006

ISBN 10: 0735621977
ISBN 13: 9780735621978

Author Bio

Dejan Sarka is MCT and MCDBA certified and a Microsoft? MVP for SQL Server?. He teaches and consults for Solid Quality Mentors, speaks at TechEd and PASS, and develops OLTP, OLAP, and data mining solutions.