Ben-Gan I. - Inside Microsoft SQL Server 2005. T-SQL Programming [2006, CHM, ENG]

Книги и журналы » Компьютерная литература » СУБД

Inside Microsoft SQL Server 2005: T-SQL Programming

Год: 2006
Автор: Ben-Gan I.
Жанр: Учебное пособие
ISBN: 0735621977, 978-0735621978
Язык: Английский
Формат: CHM
Качество: Изначально компьютерное (eBook)
Количество страниц: 544

Описание: 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
[spoiler="Примеры страниц"]

[/spoiler]
[spoiler="Оглавление"]
Table of Contents
Inside Microsoft SQL Server 2005— T-SQL Programming
Foreword
Preface
Introduction
Chapter 1 - Datatype-Related Problems, XML, and CLR UDTs
Chapter 2 - Temporary Tables and Table Variables
Chapter 3 - Cursors
Chapter 4 - Dynamic SQL
Chapter 5 - Views
Chapter 6 - User-Defined Functions
Chapter 7 - Stored Procedures
Chapter 8 - Triggers
Chapter 9 - Transactions
Chapter 10 - Exception Handling
Chapter 11 - Service Broker
Appendix A - Companion to CLR Routines
Index
List of Figures
List of Tables
List of Listings
List of Sidebars
[/spoiler]
Опубликовано группой