Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric SQL database in Microsoft Fabric
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 Analytics Platform System (PDW) (review each individual statement for details). Use these statements to add, modify, query, or remove data from a SQL Server database.
In This SectionThe 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, UPDATERetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4