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.
- ISBN10 0735621977
- ISBN13 9780735621978
- Publish Date 25 October 2006
- Publish Status Out of Print
- Out of Print 3 April 2014
- Publish Country US
- Imprint Microsoft Press,U.S.
- Format Paperback
- Pages 544
- Language English