Inside Microsoft® SQL Server? 2005 : T-SQL Programming

Sarka, Dejan, Ben-Gan, Itzik, Wolter, Roger, Kollar, Lubor

ISBN 10: 0735621977 / ISBN 13: 9780735621978

Published by Microsoft Press, 2006

About this Item

Ships from the UK. Used book that is in clean, average condition without any missing pages. Seller Inventory # GRP86570518

Bibliographic Details

Title: Inside Microsoft® SQL Server? 2005 : T-SQL ...

Publisher: Microsoft Press

Publication Date: 2006

Binding: Soft cover

Condition: Good

Edition: 2005 Ed.

About this title

Synopsis:

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.

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