T-SQL

Technology & Computing abbreviation · Data & Database

T-SQL
Stands forTransact-SQL
CategoriesTechnology & Computing

T-SQL stands for Transact-SQL, a data & database abbreviation.

The proprietary SQL dialect of Microsoft SQL Server and Azure SQL, and originally of Sybase, adding variables, control flow, TRY...CATCH error handling and stored procedures.

Example: The report is generated by a T-SQL stored procedure scheduled in SQL Server Agent.

Usage notes

Originated at Sybase in the 1980s; Microsoft licensed Sybase's database for the first SQL Server, and the two dialects diverged afterward. T-SQL uses TOP where many other databases use LIMIT, and square brackets to quote identifiers. It is the language of SQL Server Management Studio scripts.

More data & database abbreviations

  • 3NF – Third normal form
  • ACID – Atomicity, consistency, isolation, durability
  • BASE – Basically available, soft state, eventual consistency
  • BI – Business intelligence
  • BLOB – Binary large object
  • BSON – Binary JSON
  • CAP – Consistency, availability, partition tolerance (CAP theorem)
  • CDC – Change data capture
  • CTE – Common table expression
  • DAG – Directed acyclic graph
  • DAX – Data Analysis Expressions
  • DB – Database

See all 53 data & database abbreviations →