What is a T-SQL query?


In the Stack Exchange Data Explorer , specifically in the first line says:


Click the Compose Query button up and start typing your T-SQL query [...]

What a free translation would be:


Click the Query button above and start typing your query T-SQL [...]

  • What is a T-SQL query?
  • What does it differ from a normal query ?
  • Which database uses this query T-SQL?
asked by anonymous 04.10.2017 / 16:01

1 answer


Transact-SQL , abbreviated as T-SQL is owned by Microsoft and Sybase for the SQL extension.


What is a T-SQL query?

A SQL query tailored for SQL Server.


How does it differ from a normal query?

  • Language flow control
  • Local Variables
  • Various support functions for processing strings, dates, math, etc.
  • Enhancement for the DELETE and UPDATE

Which database uses this T-SQL query?

SQL Server.


04.10.2017 / 16:10