Inside Microsoft® SQL Server™ 2005

T-SQL Programming

Do you like this document?

Notes

Please login to add notes

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.

Page_place_entryicon_cmyk_1201111
Uvk
Oreilly-media-logo3
Packtpublishing