Sybase Technical Library - Product Manuals Home

Return to Collection List
Enable Frames

[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search

Table of contents for What's New in SYBASE SQL Server Release 10.0?

[-] Chapter 1: New Features in SQL Server Release 10.0
Introduction
New Installation and Upgrade Utility
[+] Addition to System Databases
[+] Backup/Space Management
[+] New Security Features
Cursors
[+] Data Definition Enhancements
[+] Transactions, Triggers, and Stored Procedures Changes
[+] Query/Data Modification Changes
[-]
ANSI Compatibility
set Commands Required for ANSI Compliance
FIPS Flagger
SQLSTATE Messages and Codes
The escape Clause in the like Predicate
ANSI-Style Comments
Changes to set Options arithabort and arithignore
Synonymous Keywords
Chained Transactions and Isolation Levels
Delimited Identifiers
Treatment of Nulls
Right Truncation of Character Strings
Permissions Required for update and delete Statements
[+] Enhancements to Permissions
Error Handling
create index Performance Enhancements
Improvements to the Query Optimizer
Bulk Copy Performance Enhancements
Spanish Collating Orders
Document Reorganization
[+] Summary by Command Name, Type, Tables Affected
[+] Chapter 2: Changes That May Affect Existing Applications
[+] Chapter 3: Changes in SQL Server Releases 4.8, 4.9, and 4.9.1