Libro – Inside Microsoft SQL Server 2005: T-SQL Programming

image

Acerca del Libro:

Exploit advanced T-SQL language features with in-depth architectural insights from the experts.
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.

Descubre como:

  • 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 application

    Tabla de Contenido:

    · 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

    Sitio Oficial: Inside Microsoft® SQL Server™ 2005: T-SQL Programming

    Descarga AQUI – Megaupload Formato .chm(Microsoft Compiled HTML Help)

  • Acerca de ArturoMezDa

    Ing.Sistemas Computacionales

    Publicado el 22 noviembre, 2010 en Desarollo, Descargas, Libros, Software y etiquetado en , , , , , , . Guarda el enlace permanente. Deja un comentario.

    Deja un comentario

    Introduce tus datos o haz clic en un icono para iniciar sesión:

    Logo de WordPress.com

    Estás comentando usando tu cuenta de WordPress.com. Cerrar sesión / Cambiar )

    Imagen de Twitter

    Estás comentando usando tu cuenta de Twitter. Cerrar sesión / Cambiar )

    Foto de Facebook

    Estás comentando usando tu cuenta de Facebook. Cerrar sesión / Cambiar )

    Google+ photo

    Estás comentando usando tu cuenta de Google+. Cerrar sesión / Cambiar )

    Conectando a %s

    A %d blogueros les gusta esto: