Types of TSQL Statements:

Data Query Langauge (DQL)

• Commands used to get data from the database and impose ordering upon it

Data Manipulation Language (DML)

• Users move data into out of databases and also modify the data in the database
• SELECT, INSERT, UPDATE, DELETE

Data Definition Language (DDL)

• Is used to create, alter, and delete database objects
• CREATE, ALTER, DROP, TRUNCATE

Data Control Language (DCL)

• Consists of commands that control the user access to the database objects
• GRANT, DENY, REVOKE

Transaction Control Language (TCL)

• Commands allow the users to control transaction 
• ROLLBACK, COMMIT