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.
EAN/ISBN : 9781430210023
Publisher(s): Springer, Berlin, APress
Discussed keywords: Microsoft SQL Server 2008
Format: ePub/PDF

Author(s): Coles, Michael