Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Data Manipulation Language (DML) is a vocabulary used to retrieve and work with data in SQL Server 2012. 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 |