What is T-SQL used for?

Is T-SQL the same as SQL?

T-SQL, which stands for Transact-SQL and is sometimes referred to as TSQL, is an extension of the SQL language used primarily within Microsoft SQL Server. This means that it provides all the functionality of SQL but with some added extras.

What are the functions of T-SQL?

T-SQL FunctionsAggregate functions, which operate on a collection of values, but return one summary value.Ranking functions, which return a ranking value for every row within a partition.Rowset functions, which return an object that can be used as a table reference in SQL statements.What is T-SQL (Transact-SQL)? - Definition from WhatIs.com

What are the advantages of T-SQL?

Advantages of using T-SQL It is built with aided logging and transaction knowledge in the environment and thus promoting reliability. Efficiency: It minimizes traffic over the server. the jobs being run with data are processed with minimal overhead when being transferred within the application.

Is T-SQL a programming language?

Transact-SQL (T-SQL) provides a robust programming language with features that let you temporarily store values in variables, apply conditional execution of commands, pass parameters to stored procedures, and control the flow of your programs.