DML Statements

Start Omhoog SELECT WHERE GROUP BY JOIN

Data Manipulation Language (DML) Statements (Transact-SQL)

 
Data Manipulation Language (DML) is a vocabulary used to retrieve and work with data in SQL Server 2014. 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
FROM (Transact-SQL) DELETE, SELECT, UPDATE
Hints (Transact-SQL) DELETE, INSERT, SELECT, UPDATE
OPTION Clause (Transact-SQL) DELETE, SELECT, UPDATE
OUTPUT Clause (Transact-SQL) DELETE, INSERT, MERGE, UPDATE
Search Condition (Transact-SQL) DELETE, MERGE, SELECT, UPDATE
Table Value Constructor (Transact-SQL) FROM, INSERT, MERGE
TOP (Transact-SQL) DELETE, INSERT, MERGE, SELECT, UPDATE
WHERE (Transact-SQL) DELETE, SELECT, UPDATE
WITH common_table_expression (Transact-SQL) DELETE, INSERT, MERGE, SELECT, UPDATE