Pro T-SQL 2008 Programmer's Guide
Autor principal: | |
---|---|
Autor Corporativo: | |
Formato: | eBook |
Lenguaje: | English |
Publicado: |
Berkeley, CA :
Apress : Imprint: Apress,
2008.
|
Edición: | 1st ed. 2008. |
Materias: | |
Acceso en línea: | https://doi.org/10.1007/978-1-4302-1002-3 |
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.