Transact-SQL Extensions

Transact-SQL enhances the power of SQL, and minimizes the occasions on which users must resort to a programming language to accomplish a desired task. Transact-SQL capabilities go beyond the ISO standards and the many commercial versions of SQL.

See, Reference Manual: Commands for the Transact-SQL extensions for each command.