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.
