New and changed Transact-SQL commands

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

Table 3-5: New commands

Command

Description

set identity_update

Updates the value of the IDENTITY column on a table.

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

Table 3-6: 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.