A DML command that modifies values in rows already in a table; if no WHERE clause is given, every row is changed.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains UPDATE in context, with comparison tables and the common traps.
Terms in this definition
- DML
Data Manipulation Language, the SQL statements SELECT, INSERT, UPDATE and DELETE, which act on the rows held in tables.
- VALUES
Returns in DAX the distinct column values, or table rows, still visible after filters are applied, sometimes with an extra blank entry. CALCULATE often takes the result as a table filter.
- Event
Table in Log Analytics where entries from Windows event logs are kept.
- WHERE
Limits a SELECT, UPDATE or DELETE to just the rows meeting a condition. Omit it, and the statement hits every row.