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

Former library book; may include library markings. Used book that is in clean, average condition without any missing pages.

Seller Inventory # 17227654-20

Bibliographic Details

• Title: Inside Microsoft® SQL Serverâ ˘ 2005 : T-SQL Programming
• Publisher: Microsoft Press
• Publication Date: 2006
• Language: English
• ISBN 10: 0735621977
• ISBN 13: 9780735621978
• Binding: Soft cover
• Edition: 2005 Ed.
• Condition: Good

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.

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.