Synonymous keywords

Table 1-2 lists keywords that have been added for SQL standard compatibility that are synonymous with existing Transact-SQL keywords.

Table 1-2: ANSI-compatible keyword synonyms

Current syntax

Additional syntax

commit tran, commit transaction, rollback tran, rollback transaction

commit work, rollback work

any

some

grant all

grant all privileges

revoke all

revoke all privileges

max (expression)

max ([all | distinct]) expression

min (expression)

min ([all | distinct]) expression

user_name function

user keyword