New and changed Transact-SQL commands

This section describes the new and changed Transact-SQL commands in version 12.0.

Table 6-3 summarizes the new Transact-SQL commands.

**Table 6-3: New commands**
Command	Function
quiesce database	Suspends and resumes updates to a specified list of databases.
join	Indicates the join uses ANSI syntax for either an inner or outer join.
remove java	Removes one or more Java classes, packages, or JARs from the database.

Table 6-4 summarizes the changes to existing Transact-SQL commands.

**Table 6-4: Changed commands**
Command	Change
alter role	Includes new lock, unlock, and all overrides options to change the lock status of a role. Includes new passwd expiration, max failed_logins, and min passwd length options to change the password expiration interval, the minimum password length, and the maximum number of failed logins allowed for a specified role.
alter table	Includes new off row and in row options to specify storage for Java-SQL columns.
create role	Includes new lock, unlock, and all overrides options to set the lock status of a role. Includes new passwd expiration, min passwd length, and max failed_logins options to set the password expiration interval, the minimum password length, and the maximum number of failed logins allowed for a specified role.
create table	Includes new off row and in row options to specify storage for Java-SQL columns.
dbcc	Includes new commands for heuristically completing distributed transactions. Includes new rebuild_text command for rebuilding or creating internal data structures for text or image data. Adaptive Server uses these data structures to perform random access and asynchronous prefetch for queries against text or image data.
disk init	Includes the new dsync option to control buffered writes to devices.
disk reinit	Includes the new dsync option to control buffered writes to devices.
execute	Includes the new execute() syntax to dynamically execute Transact-SQL commands.

Table 6-5 summarizes the new and changed options for the set command:

**Table 6-5: New and changed set command options**
set option	Description
clientapplname	Assigns an application an individual name for the current session.
clienthostname	Assigns a host an individual name for the current session.
clientname	Assigns a client an individual name for the current session.
strict_dtm_enforcement	Determines whether the Adaptive Server propagates transactions to servers that do not support Adaptive Server transaction coordination services.
transactional_rpc	Determines whether or not Adaptive Server coordinates remote procedure calls and updates to remote server data.

Table 6-6 summarizes the new Transact-SQL functions.

**Table 6-6: New Transact-SQL functions**
Function	Description
license_enabled	Returns 1 if a feature’s license is enabled, 0 if the license is not enabled, or null if you specify an invalid license name.