Manyebook

Inside Microsoft SQL Server 2005: T-SQL Programming

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.

  • Format
  • paperback
  • Pages
  • 536
  • Language
  • english
  • ISBN
  • 9780735621978
  • Genres
  • technical
  • Release date
  • 2006