Data Manipulation Language (DML)

In this page, we will explore the useful Data Manipulation Language (DML) commands such as Insert, Update along with examples.

Add Column

Aggregate Functions

ALL

AND

ANY

Approx_Count_Distinct

BETWEEN

CASE

CAST

CHARINDEX

COALESCE

Column & Table Aliases

Common Table Expressions (CTE)

Convert

Correlated Subquery

Count

CROSS APPLY

CROSS JOIN

CUBE

DATEADD

DATEDIFF

DATEPART

DELETE

EXCEPT

EXISTS

FULL OUTER JOIN

GROUP BY

GROUPING SETS

HAVING

IF

IN

INNER JOIN

INSERT

INSERT INTO SELECT

INSERT Multiple Rows

INTERSECT

ISNULL

Joins

JOIN

LEFT JOIN

LIKE

MERGE

Not NULL

NULL

OFFSET FETCH

OR

ORDER BY

OUTER Join

PARTITION BY

PIVOT

Ranking Functions

Recursive CTE

Replace

RIGHT JOIN

ROLLUP

ROW_NUMBER

SELECT

SELECT DISTINCT

SELECT INTO

SELECT TOP

Self Join

STRING_SPLIT

Subquery

Triggers

TRIM

TRY_Convert

TRY_PARSE

Union

Union All

UPDATE

UPDATE JOIN

Where


SQLShack

SQLShack

SQL Shack was created as a community service from ApexSQL, with the goal to share SQL Server knowledge through articles written by SQL Server professionals and community members
SQLShack

Latest posts by SQLShack (see all)