SQL Server Data Manipulation Language (DML)

Data Manipulation Language is composed of the following commands:

 

SELECT (SQL Statement)

INSERT (SQL Statement)

UPDATE (SQL Statement)

DELETE (SQL Statement)

 

Other statements include:

SELECT INTO

BULK INSERT

TRUNCATE TABLE

READTEXT

WRITETEXT

UPDATETEXT