Inside Microsoft® SQL ServerTM 2005: T-SQL Programming

Front Cover
Microsoft Press, Nov 30, 2009 - Computers - 536 pages

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.

What people are saying - Write a review

We haven't found any reviews in the usual places.

About the author (2009)

Itzik Ben-Gan is a mentor and cofounder of Solid Quality Mentors. A Microsoft MVP for SQL Server since 1999, Ben-Gan teaches and consults internationally on T-SQL querying, programming, and query tuning. He is the coauthor of Inside Microsoft SQL Server: T-SQL Querying and Inside Microsoft SQL Server: T-SQL Programming. He has written numerous articles for SQL Server Magazine and MSDN(R), and speaks at industry events such as Microsoft Tech*Ed, DevWeek, PASS, and SQL Server Connections.

Lubor Kollar is a program manager on the SQL Server team at Microsoft Corporation who focuses on optimization. Lubor Kollar lives in Redmond, Washington.

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

Bibliographic information