Chapter 1: SQL Building Blocks

Synonymous keywords

Several keywords added for SQL standard compatibility are synonymous with existing Transact-SQL keywords.

**Table 1-9: 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() built-in function	user keyword