Inside Microsoft SQL Server 2005: T-SQL Programming (Pro-developer) - Softcover

Ben-gan, Itzik; Dejan Sarka; Roger Wolter

4.33

49 ratings by Goodreads

9780735621978: Inside Microsoft SQL Server 2005: T-SQL Programming (Pro-developer)

Softcover

ISBN 10: 0735621977 ISBN 13: 9780735621978

Publisher: Microsoft Press, 2006

View all copies of this ISBN edition:

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

"synopsis" may belong to another edition of this title.

From the Publisher:

Key Book Benefits: - Delivers practical, hands-onuidance on sophisticated uses of T-SQL, including triggers, user-defined functions, exception handling, and much more

- Provides deep background information that helps developers effectively employ cursors and views, and understand how to use Service Broker

- Helps promote mastery of T-SQL

- Features numerous code and table examples, practical advice, logic puzzles, and best practices

About the Author:

Dejan Sarka is MCT and MCDBA certified and a Microsoft MVP for SQL Server. He teaches and consults for Solid Quality Mentors, speaks at TechEd and PASS, and develops OLTP, OLAP, and data mining solutions.

"About this title" may belong to another edition of this title.