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
Datatype Conversion Changes
New Hex Conversion Functions
Subquery Changes
Grouping on bit Columns Allowed
Random Number Generator Improvements
between Predicate Changes
select into Column Headings
Column Alias
Full Dynamic SQL/Precompiler Support
Right Truncation of Character Strings
[+] ANSI Compatibility
[+] 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