Inside Microsoft SQL Server 2008 T-SQL Programming (Developer Reference)

Inside Microsoft SQL Server 2008 T-SQL Programming (Developer Reference)

Itzik Ben-Gan, Greg Low

Get an in depth examine the interior structure of T-SQL with this entire programming reference. Database builders and directors get most sensible practices, specialist strategies, and code samples to grasp the intricacies of this programming language—solving complicated issues of real-world solutions.

Discover how to:

  • Work with T-SQL and CLR user-defined services, kept tactics, and triggers.
  • Handle transactions, concurrency, and mistake handling.
  • Efficiently use transitority items, together with transitority tables, desk variables, and desk expressions.
  • Evaluate while to exploit set-based programming thoughts and whilst to exploit cursors.
  • Work with dynamic SQL in an effective and safe manner.
  • Treat date- and time-related info in a powerful manner.
  • Develop CLR user-defined forms and find out about temporal aid within the relational model.
  • Use XML and XQuery and enforce a dynamic schema solution.
  • Work with spatial information utilizing the hot geometry and geography kinds and spatial indexes.
  • Track entry and adjustments to info utilizing prolonged occasions, SQL Server Audit, switch monitoring, and alter info capture.
  • Use provider dealer for managed asynchronous processing in database applications.

All the book’s code samples should be to be had for obtain from the better half net site.

Show sample text content

Download sample