Capabilities

T-SQL or Transact SQL is the query language specific to the Microsoft SQL Server product. It can help perform operations like retrieving the data from a single row, inserting new rows, and retrieving multiple rows. It is a procedural language that is used by the SQL Server. T-SQL is a procedural language used by Microsoft in SQL Server. It adds declared variables, transaction control, error and exception handling, and row processing to SQL. The syntax of the T-SQL is distinct from PL-SQL. However, it has the same functionality and gives similar results to other languages.