Transact-SQL

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.