Transact-SQL

Transact -SQL ( TSQL ) is an extension of the SQL standard by Sybase and Microsoft, and includes error handling, row processing and variable declaration.

Use

• One can store programs ( stored procedures ) on the database server, thus extending the functionality of the database; any user of the database can call these programs and use. Permissions can be assigned for each Transact- SQL procedure to individual users.
• Programming of database triggers