3 4
T-SQL is an enhancement of the standard SQL programming language. It is the primary language used for communications between applications and SQL Server. T-SQL provides the DDL and DML capabilities of standard SQL, plus extended functions, system stored procedures, and programming constructs (such as IF and WHILE) to allow more flexibility in programming. The capabilities of T-SQL continue to grow with new versions of SQL Server. Let's look at some of the new features of T-SQL.