Pro T-SQL 2008 Programmer's Guide

Mostrar otras versiones (1)

Discussing new and existing features, SQL Server designer and administrator Michael Coles takes you on an expert guided tour of Transact-SQL functionality in SQL Server 2008 in his book, Pro T-SQL 2008 Programmer's Guide. Fully functioning examples and downloadable source code bring Coles'...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Coles, Michael (Autor)
Autor Corporativo: SpringerLink (Online service)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Berkeley, CA : Apress : Imprint: Apress, 2008.
Edición:1st ed. 2008.
Temas:
Database management.
Microprogramming .
Database Management.
Control Structures and Microprogramming.
Acceso en línea:Texto Completo
Tabla de Contenidos:
  • The Role of T-SQL
  • Tools of the Trade
  • T-SQL for SQL Server 2000 Programmers
  • Expand coverage, add new statements like MERGE
  • New data types: Spatial data, vardecimal, etc
  • Control-of-Flow and CASE Expressions
  • User-Defined Functions
  • Expand coverage, table parameters, etc
  • Stored Procedures
  • Expand coverage, table parameters, etc
  • Parameter sniffing
  • Triggers
  • Expand coverage
  • T-SQL Encryption
  • Expand coverage, include new encryption functions
  • Expand discussion of SQLCLR encryption
  • Error Handling and Debugging
  • Dynamic SQL
  • XML
  • XQuery and XPath
  • Expanded discussion of XQuery and XPath
  • SQL Metadata
  • Additional catalog view information
  • Additional coverage of system functions
  • SQLCLR Programming
  • .NET Client Programming
  • HTTP Endpoints
  • Cursors * new *
  • Full-Text Search * new *
  • Query Optimization and Performance Enhancement * new *
  • SQL Keywords
  • XQuery Data Types
  • XQuery Terms
  • Selected T-SQL Source Code Listings
  • .NET Source Code Listings.

Ejemplares similares