Now Available Inside Microsoft SQL Server 2008 T-SQL Programming
10/8/2009
Page Content
This comprehensive T-SQL programming reference by Itzik Ben-Gan and coauthors Dejan Sarka, Roger Wolter, Greg Low, Ed Katibah, and Isaac Kunen gives database developers and administrators best practices, expert techniques, and code samples to master the language and build real-world solutions to the most complex problems.
With this detailed look at the internal architecture of T-SQL, you’ll discover how to work with T-SQL and CLR user-defined functions, stored procedures, and triggers as well as how to handle transactions, concurrency, and error handling. You’ll also learn how to efficiently use temporary objects, including temporary tables, table variables, and table expressions.
The 832-page book gives you the information you need to evaluate when to use set-based programming techniques and when to use cursors. You’ll also see how to work with dynamic SQL efficiently and securely and how to treat date- and time-related data in a robust manner.
In addition, you’ll see how to develop CLR user-defined types, learn about temporal support in the relational model, explore XML and XQuery, and learn how to implement a dynamic schema solution. The book also covers working with spatial data using the new geometry and geography types and spatial indexes as well as tracking access and changes to data using extended events, SQL Server Audit, change tracking, and change data capture. You’ll even read about using Service Broker for controlled asynchronous processing in database applications.
All the book’s code samples are available for download from the companion Web site.
Order now