Data Manipulation Language (DML) Statements (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content

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

 

Data Manipulation Language (DML) is a vocabulary used to retrieve and work with data in SQL Server 2016. 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.

BULK INSERT (Transact-SQL)SELECT (Transact-SQL)
DELETE (Transact-SQL)UPDATE (Transact-SQL)
INSERT (Transact-SQL)UPDATETEXT (Transact-SQL)
MERGE (Transact-SQL)WRITETEXT (Transact-SQL)
READTEXT (Transact-SQL)

The following table lists the clauses that are used in multiple DML statements or clauses.

ClauseCan 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

Community Additions

ADD
Show:
© 2016 Microsoft