Transact SQL is a Microsoft standard SQL. Transact SQL is used to perform operations only in SQL Server. It is a procedural language.
T-SQL = SQL + Programming Constructs.
There are four types of T-SQL Commands.
- DDL (Data Definition Language)
- DML (Data Manipulation Language)
- DCL (Data Control Language)
- TCL (Transaction Control Language)
DDL – Data Definition Language:
DDL commands are used to define the structure of the table in the databse. The following are the DDL commands:
DML – Data Manipulation Language:
DML commands are used to manipulate the data in the database. The following are the DML commands:
DCL – Data Control Language:
DCL commands are used to control the data in the database. The following are the DCL commands:
TCL – Transaction Control Language:
TCL commands are used to control the transactional activities in the database. The following are the TCL commands: