Jump to content

Transact-SQL

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by 24.235.244.90 (talk) at 04:51, 24 August 2004 (Category:Data-centric programming languages). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

Transact-SQL is Microsoft's and Sybase's proprietary extension to the SQL language. In order to make it more powerful, SQL has been enhanced with additional features such as:

  • Control-of-flow language
  • Stored procedures
  • Triggers.
  • User-defined functions
  • Row-by-row processing (cursor support)
  • Updateable views
  • XML queries and result sets
  • User authentication integrated with Microsoft Windows
  • Various support functions for string processing, date processing, mathematics, etc.

See also