Inside Microsoft® SQL Server® 2008: T-SQL Programming: O'Reilly - Safari Books Online

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Start Reading

Buy Print Version

Inside Microsoft® SQL Server® 2008: T-SQL Programming

Inside Microsoft® SQL Server® 2008: T-SQL Programming
By: Itzik Ben-Gan; Dejan Sarka; Greg Low; Roger Wolter; Ed Katibah; Isaac Kunen
Publisher: Microsoft Press
Pub. Date: September 23, 2009
Print ISBN-13: 978-0-7356-2602-7
Pages in Print Edition: 834
Subscriber Rating: 0 [0 Ratings]

Subscriber Reviews • Browse Similar Topics

Overview

Get a detailed look at the internal architecture of Transact-SQL (T-SQL)—the database programming language built into SQL Server—with this comprehensive, hands-on programming reference.

Subscriber Reviews

Average Rating: 0 out of 5 rating Based on 0 Ratings

No Subscribers have provided a review for this book.

Browse Similar Topics

Top Level Categories:
Information Technology & Software Development
Product
Vendor

Sub-Categories:
Information Technology & Software Development > Databases
Databases > Microsoft SQL Server
Product > Microsoft SQL Server 2008
Vendor > Microsoft

Table of Contents

View Sample

Inside Microsoft® SQL Server® 2008: T-SQL Programming

View Sample

View Sample

View Sample

Acknowledgments

View Sample

Introduction

View Sample

Hardware and Software Requirements

View Sample

Companion Content and Sample Database

View Sample

Find Additional Content Online

View Sample

Support for These Books

View Sample

1. Views

View Sample

What Are Views?

View Sample

ORDER BY in a View

View Sample

Refreshing Views

View Sample

Modular Approach

View Sample

View Sample

View Sample

View Sample

View Sample

2. User-Defined Functions

View Sample

Some Facts About UDFs

View Sample

View Sample

Table-Valued UDFs

View Sample

View Sample

View Sample

3. Stored Procedures

View Sample

Types of Stored Procedures

View Sample

The Stored Procedure Interface

View Sample

View Sample

Dependency Information

View Sample

Compilations, Recompilations, and Reuse of Execution Plans

View Sample

View Sample

Parameterizing Sort Order

View Sample

CLR Stored Procedures

View Sample

View Sample

4. Triggers

View Sample

View Sample

View Sample

View Sample

View Sample

View Sample

5. Transactions and Concurrency

View Sample

What Are Transactions?

View Sample

Locking and Blocking

View Sample

Lock Escalation

View Sample

Isolation Levels

View Sample

View Sample

View Sample

View Sample

6. Error Handling

View Sample

Error Handling without the TRY/CATCH Construct

View Sample

Error Handling with the TRY/CATCH Construct

View Sample

View Sample

7. Temporary Tables and Table Variables

View Sample

Temporary Tables

View Sample

Table Variables

View Sample

tempdb Considerations

View Sample

Table Expressions

View Sample

Comparison Summary

View Sample

Summary Exercises

View Sample

View Sample

8. Cursors

View Sample

View Sample

Cursor Overhead

View Sample

Dealing with Each Row Individually

View Sample

Order-Based Access

View Sample

View Sample

9. Dynamic SQL

View Sample

View Sample

View Sample

Environmental Settings

View Sample

Uses of Dynamic SQL

View Sample

View Sample

View Sample

10. Working with Date and Time

View Sample

Date and Time Data Types

View Sample

Date and Time Manipulation

View Sample

Date- and Time-Related Querying Problems

View Sample

View Sample

11. CLR User-Defined Types

View Sample

Theoretical Introduction to UDTs

View Sample

Programming a UDT

View Sample

View Sample

12. Temporal Support in the Relational Model

View Sample

Timestamped Predicates and Propositions

View Sample

Semitemporal Problems

View Sample

Tables with Full Temporal Support

View Sample

Unpack and Pack

View Sample

Sixth Normal Form in Use

View Sample

View Sample

13. XML and XQuery

View Sample

Converting Relational Data to XML and Vice Versa

View Sample

The XQuery Language in SQL Server 2008

View Sample

View Sample

Dynamic Relational Schema

View Sample

View Sample

14. Spatial Data

View Sample

Introduction to Spatial Data

View Sample

Basic Spatial Data Concepts

View Sample

View Sample

Getting Started with Spatial Data

View Sample

Spatial Data Validity

View Sample

Measuring Length and Area

View Sample

Indexing Spatial Data

View Sample

Using Spatial Data to Solve Problems

View Sample

Extending Spatial Support with CLR Routines

View Sample

View Sample

15. Tracking Access and Changes to Data

View Sample

Which Technology Do I Use?

View Sample

Extended Events Implementation

View Sample

SQL Server Audit Implementation

View Sample

Change Tracking Implementation

View Sample

Change Data Capture Implementation

View Sample

View Sample

16. Service Broker

View Sample

Dialog Conversations

View Sample

View Sample

Conversation Priority

View Sample

View Sample

Poison Messages

View Sample

Dialog Security

View Sample

Routing and Distribution

View Sample

Troubleshooting

View Sample

View Sample

Where Does Service Broker Fit?

View Sample

View Sample

A. Companion to CLR Routines

View Sample

Create the CLRUtilities Database: SQL Server

View Sample

Development: Visual Studio

View Sample

Deployment and Testing: Visual Studio and SQL Server

View Sample

B. About the Authors

View Sample

View Sample

About the Authors

View Sample

Extras

The publisher has provided additional content related to this title.

Description	Content
Visit the catalog page for Inside Microsoft® SQL Server® 2008: T-SQL Programming	Catalog Page
Visit the errata page for Inside Microsoft® SQL Server® 2008: T-SQL Programming	Errata