Transact-SQL
Appearance
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.