T-SQL (Transact SQL) is an sql statements based and data centric language, typically used for operations over a database in Microsoft SQL Server. It provides features such as transaction control, logic such as conditions and loops, exceptions and errors handling, row processing, and declaration of variables. It is the SQL Server native programming language.
SQL commands and statements are categorized into the following groups:
DDL, DML, DCL, and TCL
Programmability objects you can create using T-SQL on SQL Server 2005/2008 are:
- Stored Procedure
- Table-valued Function
- Scalar-valued Function