Pro T-SQL 2008 Programmer's Guide

Pro T-SQL 2008 Programmer's Guide

Bibliographic Details
Main Author: Coles, Michael. (Author)
Corporate Author: SpringerLink (Online service)
Format: eBook
Language:English
Published: Berkeley, CA : Apress : Imprint: Apress, 2008.
Edition:1st ed. 2008.
Subjects:
Database management.
Microprogramming .
Database Management.
Control Structures and Microprogramming.
Online Access:https://doi.org/10.1007/978-1-4302-1002-3
Table of Contents:
  • 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.

Similar Items