What's New in SYBASE SQL Server Release 10.0?

Home

Transactions, Triggers, and Stored Procedures Changes

What's New in SYBASE SQL Server Release 10.0?

Chapter 1: New Features in SQL Server Release 10.0

Query/Data Modification Changes

Datatype Conversion Changes

Changes were made to datatype conversion rules for this release to provide greater consistency across all SYBASE products.

Formerly disallowed conversions to and from binary datatypes are now allowed.
Conversion from integer to character now returns an error instead of "**" if the character value is not long enough to store the converted value.
Some changes were made to the "datatype hierarchy" that controls the output datatype of mixed-mode datatype operations.

See Chapter 2, "Changes That May Affect Existing Applications" , for information on how these changes may affect existing applications. The new hierarchy is included in the "Datatypes" section of Volume 1 in the SQL Server Reference Manual .

Additional information about datatype conversions is provided in "Datatype Conversion Functions" in Volume 1 of the SQL Server Reference Manual and Chapter 9, "Using the Built-In Functions in Queries" in the Transact-SQL User's Guide .

New Hex Conversion Functions

Two new functions provide platform-independent conversions between integer values and hexadecimal strings. See "Datatype Conversion Functions" in Volume 1 of the SQL Server Reference Manual and Chapter 9, "Using the Built-In Functions in Queries" in the Transact-SQL User's Guide for information about inttohex and hextoint .

Subquery Changes

The behavior of certain subqueries has changed. See Chapter 2, "Changes That May Affect Existing Applications" for detailed information about these changes, and how they may affect your existing applications.

Grouping on bit Columns Allowed

You can now use group by on bit columns.

Random Number Generator Improvements

The rand function now uses the output of a 32-bit pseudo-random integer generator. See "Mathematical Functions" in Volume 1 of the SQL Server Reference Manual for more information.

between Predicate Changes

In some cases, the between predicate in Transact-SQL returned results whether the values supplied were in the proper order (lower number first after the predicate) or swapped (higher number first). In Release 10.0, a query with swapped between values returns no rows.

select into Column Headings

In a select into statement, column headings must be provided for any select list item that includes aggregate functions or expressions. See Chapter 2 for examples of expressions that require headings, and for examples and syntax.

Column Alias

You can now use the keyword as in select statements between the select expression and the alias name. For example:

 select au_lname as lastname from authors

Full Dynamic SQL/Precompiler Support

SQL Server Release 10.0 provides full support for host variables and Dynamic SQL. Full documentation can be found in Embedded SQL/C and Embedded SQL/COBOL Programmer's Guides .

Right Truncation of Character Strings

In previous releases, SQL Server silently truncated char , nchar , varchar , and nvarchar strings when an insert or update entered strings longer than the specified column length. A new set option, string_rtruncation , controls silent truncation of character strings. Set this option on to prohibit silent truncation and enforce ANSI behavior. See "set" in Volume 1, Chapter 1 of the SQL Server Reference Manual for more information.


	Expand Search