Chapter 5: New Features in Adaptive Server Version 12.5.0.x

New and changed Transact-SQL commands

Table 5-4 summarizes the new Transact-SQL commands in version 12.5.0.3.

**Table 5-4: New commands**
Command	Description
set identity_update	Updates the value of the IDENTITY column on a table.

Table 5-5 summarizes the changes to existing Transact-SQL commands in version 12.5.0.3.

**Table 5-5: Changed commands**
Command	Change
update statistics	Adds the *sampling=percent* percent** option, which specifies a sampling percent.
dbcc	Adds these new parameters: pravailabletempdbs – prints the global list of available temporary databases. addtempdb – adds a temporary database to the global list of available temporary databases.
create database	Adds the temporary parameter, which creates a temporary database.