Monday, January 26, 2009

Transact-SQL

Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to SQL. Microsoft's implementation ships in the Microsoft SQL Server product. Sybase uses the language in its Adaptive Server Enterprise, the successor to Sybase SQL Server.

Transact-SQL enhances SQL with these additional features:

* Control-of-flow language
* Local variables
* Various support functions for string processing, date processing, mathematics, etc.
* Improvements [citation needed] to DELETE and UPDATE statements.

No comments: