|
About the Book
Exploit advanced T-SQL language features with in-depth architectural insights from the experts.
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
Related Books
Microsoft® SQL Server® 2008 Analysis Services Step by Step
Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008
Programming Microsoft® SQL Server® 2008
Customer Rating
Number of Ratings: 9
| Average Rating: |
|
|
