Transact-SQL
Sign in to saveAlso known as T-SQL
Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to the SQL (Structured Query Language) used to interact with relational databases. T-SQL expands on the SQL standard to include procedural programming, local variables, various support functions for string processing, date processing, mathematics, etc. and changes to the DELETE and UPDATE statements.
~4 min read
Encyclopedic overview
8 sectionsContents
- Variables
- Flow control
- Changes to DELETE and UPDATE statements
- BULK INSERT
- TRY CATCH
- See also
- References
- External links
Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to the SQL (Structured Query Language) used to interact with relational databases. T-SQL expands on the SQL standard to include procedural programming, local variables, various support functions for string processing, date processing, mathematics, etc. and changes to the DELETE and UPDATE statements.
Transact-SQL is central to using Microsoft SQL Server. All applications that communicate with an instance of SQL Server do so by sending Transact-SQL statements to the server, regardless of the user interface of the application.
Excerpted from Wikipedia’s “Transact-SQL” article, available under the CC BY-SA 4.0 licence.