In SQL Server we write the query and create the statements. The statements
and query are segregate in following category as below:
DML (Data Manipulation Language)
In SQL Server DML is used to retrieve,
store, modify, delete, insert and update data in the database.
Ex:
SELECT, INSERT, UPDATE, and DELETE statements etc.
DDL (Data Definition
Language)
In SQL Server DML is used to create and
modify the structure of database object (s) in the database.
Ex:
CREATE, ALTER, TRUNCATE and DROP statements etc.
TCL (Transactional
Control Language)
In
SQL Server TCL is used to control different type of transactions occurred in
the database.
Ex: COMMIT Transactions,
ROLLBACK Transactions etc.
Comments