Data Manipulation Language (DML) Statements (Transact-SQL)
Data Manipulation Language (DML) is a vocabulary used to retrieve and work with data in SQL Server 2008 R2. Use these statements to add, modify, query, or remove data from a SQL Server database.
The following table lists the DML statements that SQL Server uses.
The following table lists the clauses that are used in multiple DML statements or clauses.
Clause | Can be used in these statements |
|---|---|
DELETE, SELECT, UPDATE | |
DELETE, INSERT, SELECT, UPDATE | |
DELETE, SELECT, UPDATE | |
DELETE, INSERT, MERGE, UPDATE | |
DELETE, MERGE, SELECT, UPDATE | |
FROM, INSERT, MERGE | |
DELETE, INSERT, MERGE, SELECT, UPDATE | |
DELETE, SELECT, UPDATE | |
DELETE, INSERT, MERGE, SELECT, UPDATE |
