Chapter 4: New Features in Adaptive Server Version 12.5.1

Enhanced compatibility with Microsoft SQL extensions

Adaptive Server 12.5.1 provides enhanced compatibility with Microsoft SQL extensions.

Newly supported features let you:

Use default in the insert statement. For example:

create table test_table (col1 tinyint,
   col2 tinyint default 10, col3 tinyint)

insert test_table values (11, default, 43)

Use set for variable and value assignments. For example:
```
declare @a tinyint ; set @a = 10
```
Use square brackets surrounding identifier names. For example:
```
create table [toto2] (a tinyint)
```
Use the new built-in function cast() and those added in version 12.5.0.3: len(), left(), day(), month(), year(), str_replace(), newid(), square().
Use derived tables, which can be used wherever a view can be used, and which can be used in the from list of select, select into, create view, and insert statements.
Migrate more easily between Adaptive Server and MS-SQL Server.