Queries

Applies to: yesSQL Server (all supported versions) YesAzure SQL Database YesAzure SQL Managed Instance yesAzure Synapse Analytics yesParallel Data Warehouse

Data Manipulation Language (DML) is a vocabulary used to retrieve and work with data in SQL Server and SQL Database. Most also work in Azure Synapse Analytics and Parallel Data Warehouse (review each individual statement for details). Use these statements to add, modify, query, or remove data from a SQL Server database.

In This Section

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, MATCH
WITH common_table_expression (Transact-SQL) DELETE, INSERT, MERGE, SELECT, UPDATE